﻿#region

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity.Migrations;
using System.Linq;
using xConnected.Core.Model;

#endregion

namespace xConnected.Data.Migrations
{
    internal sealed class Configuration : DbMigrationsConfiguration<DataContext>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = true;
        }

        protected override void Seed(DataContext context)
        {
            var user1 = new User
                            {
                                Email = "gorgieva.sandra123@gmail.com",
                                Username = "sandragorg88",
                                Password = "123456",
                                IsActivated = true,
                                ActivationKey = Guid.NewGuid(),
                                AccountType = 0
                            };
            var user2 = new User
                            {
                                Email = "gorgieva_sandra@yahoo.com",
                                Username = "company",
                                Password = "123456",
                                IsActivated = true,
                                ActivationKey = Guid.NewGuid(),
                                AccountType = 1
                            };
            var user3 = new User
                            {
                                Email = "gorgievasandra@yahoo.com",
                                Username = "user3",
                                Password = "123456",
                                IsActivated = true,
                                ActivationKey = Guid.NewGuid(),
                                MessageFolders =
                                    new List<MessageFolder>
                                        {
                                            new MessageFolder {Name = "Inbox", FolderType = 0},
                                            new MessageFolder {Name = "Outbox", FolderType = 1},
                                            new MessageFolder {Name = "Trash", FolderType = 2},
                                            new MessageFolder {Name = "Public", FolderType = 3}
                                        },
                                AccountType = 1
                            };
            var user4 = new User
                            {
                                Email = "goran.jovanov@gmail.com",
                                Username = "gjovanov",
                                Password = "123456",
                                IsActivated = true,
                                ActivationKey = Guid.NewGuid(),
                                MessageFolders =
                                    new List<MessageFolder>
                                        {
                                            new MessageFolder {Name = "Inbox", FolderType = 0},
                                            new MessageFolder {Name = "Outbox", FolderType = 1},
                                            new MessageFolder {Name = "Trash", FolderType = 2},
                                            new MessageFolder {Name = "Public", FolderType = 3}
                                        },
                                AccountType = 1
                            };
            var user5 = new User
                            {
                                Email = "blabla@gmail.com",
                                Username = "user5",
                                Password = "123456",
                                IsActivated = true,
                                ActivationKey = Guid.NewGuid(),
                                MessageFolders =
                                    new List<MessageFolder>
                                        {
                                            new MessageFolder {Name = "Inbox", FolderType = 0},
                                            new MessageFolder {Name = "Outbox", FolderType = 1},
                                            new MessageFolder {Name = "Trash", FolderType = 2},
                                            new MessageFolder {Name = "Public", FolderType = 3}
                                        },
                                AccountType = 1
                            };
            var user6 = new User
                            {
                                Email = "blabla1@gmail.com",
                                Username = "user6",
                                Password = "123456",
                                IsActivated = true,
                                ActivationKey = Guid.NewGuid(),
                                MessageFolders =
                                    new List<MessageFolder>
                                        {
                                            new MessageFolder {Name = "Inbox", FolderType = 0},
                                            new MessageFolder {Name = "Outbox", FolderType = 1},
                                            new MessageFolder {Name = "Trash", FolderType = 2},
                                            new MessageFolder {Name = "Public", FolderType = 3}
                                        },
                                AccountType = 1
                            };
            new List<User>
                {
                    user1,
                    user2,
                    user3,
                    user4,
                    user5,
                    user6
                }.ForEach(u => context.Users.AddOrUpdate(u));

            //LANGUAGE
            var albanian = new Language {Description = "Albanian", Key = "Albanian", ShortName = "sq"};
            var catalan = new Language {Description = "Catalan", Key = "Catalan", ShortName = "ca"};
            var german = new Language {Description = "German", Key = "German", ShortName = "de"};
            var russian = new Language {Description = "Russian", Key = "Russian", ShortName = "ru"};
            var belarussian = new Language {Description = "Belorussian", Key = "Belorussian", ShortName = "be"};
            var dutch = new Language {Description = "Dutch", Key = "Dutch", ShortName = "nl"};
            var french = new Language {Description = "French", Key = "French", ShortName = "fr"};
            var bosnian = new Language {Description = "Bosnian", Key = "Bosnian", ShortName = "bs"};
            var bulgarian = new Language {Description = "Bulgarian", Key = "Bulgarian", ShortName = "bg"};
            var croatian = new Language {Description = "Croatian", Key = "Croatian", ShortName = "hr"};
            var greek = new Language {Description = "Greek", Key = "Greek", ShortName = "el"};
            var turkish = new Language {Description = "Turkish", Key = "Turkish", ShortName = "tr"};
            var english = new Language {Description = "English", Key = "English", ShortName = "en"};
            var czech = new Language {Description = "Czech", Key = "Czech", ShortName = "cz"};
            var danish = new Language {Description = "Danish", Key = "Danish", ShortName = "da"};
            var estonian = new Language {Description = "Estonian", Key = "Estonian", ShortName = "et"};
            var finnish = new Language {Description = "Finnish", Key = "Finnish", ShortName = "fi"};
            var hungarian = new Language {Description = "Hungarian", Key = "Hungarian", ShortName = "hu"};
            var icelandic = new Language {Description = "Icelandic", Key = "Icelandic", ShortName = "is"};
            var irish = new Language {Description = "Irish", Key = "Irish", ShortName = "ga"};
            var italian = new Language {Description = "Italian", Key = "Italian", ShortName = "it"};
            var latvian = new Language {Description = "Latvian", Key = "Latvian", ShortName = "lv"};
            var lithuanian = new Language {Description = "Lithuanian", Key = "Lithuanian", ShortName = "lt"};
            var luxembourgish = new Language {Description = "Luxembourgish", Key = "Luxembourgish", ShortName = ""};
            var macedonian = new Language {Description = "Macedonian", Key = "Macedonian", ShortName = "mk"};
            var maltese = new Language {Description = "Maltese", Key = "Maltese", ShortName = "mt"};
            var moldovan = new Language {Description = "Moldovan", Key = "Moldovan", ShortName = ""};
            var norwegian = new Language {Description = "Norwegian", Key = "Norwegian", ShortName = "no"};
            var polish = new Language {Description = "Polish", Key = "Polish", ShortName = "pl"};
            var portuguese = new Language {Description = "Portuguese", Key = "Portuguese", ShortName = "pt"};
            var romanian = new Language {Description = "Romanian", Key = "Romanian", ShortName = "ro"};
            var serbian = new Language {Description = "Serbian", Key = "Serbian", ShortName = "sr"};
            var slovak = new Language {Description = "Slovak", Key = "Slovak", ShortName = "sk"};
            var slovenian = new Language {Description = "Slovenian", Key = "Slovenian", ShortName = "sl"};
            var spanish = new Language {Description = "Spanish", Key = "Spanish", ShortName = "es"};
            var swedish = new Language {Description = "Swedish", Key = "Swedish", ShortName = ""};
            var ukrainian = new Language {Description = "Ukrainian", Key = "Ukrainian", ShortName = "uk"};

            new List<Language>
                {
                    albanian,
                    catalan,
                    german,
                    russian,
                    belarussian,
                    dutch,
                    french,
                    bosnian,
                    bulgarian,
                    croatian,
                    greek,
                    turkish,
                    english,
                    czech,
                    danish,
                    estonian,
                    finnish,
                    hungarian,
                    icelandic,
                    irish,
                    italian,
                    latvian,
                    lithuanian,
                    luxembourgish,
                    macedonian,
                    maltese,
                    moldovan,
                    norwegian,
                    polish,
                    portuguese,
                    romanian,
                    serbian,
                    slovak,
                    slovenian,
                    spanish,
                    swedish,
                    ukrainian
                }.ForEach(l => context.Languages.AddOrUpdate(l));

            //TRANSLATION
            //Translation - Industry
            var translationIndustryEducationTitleEn = new Translation
                                                          {
                                                              Text = "Education",
                                                              Language = english
                                                          };
            var translationIndustryEducationTitleDe = new Translation
                                                          {
                                                              Text = "Bildung",
                                                              Language = german
                                                          };
            var translationIndustryEducationTitleHr = new Translation
                                                          {
                                                              Text = "Obrazovanje",
                                                              Language = croatian
                                                          };
            var translationIndustryInformationTitleEn = new Translation
                                                            {
                                                                Text = "Information and communication",
                                                                Language = english
                                                            };
            var translationIndustryInformationTitleDe = new Translation
                                                            {
                                                                Text = "Information und Kommunikation",
                                                                Language = german
                                                            };
            var translationIndustryInformationTitleHr = new Translation
                                                            {
                                                                Text = "Informacije i komunikacije",
                                                                Language = croatian
                                                            };
            //Translation - Country
            //English
            var translationCountryAlbaniaEn = new Translation
                                                  {
                                                      Text = "Albania",
                                                      Language = english
                                                  };
            var translationCountryAndorraEn = new Translation
                                                  {
                                                      Text = "Andorra",
                                                      Language = english
                                                  };
            var translationCountryArmeniaEn = new Translation
                                                  {
                                                      Text = "Armenia",
                                                      Language = english
                                                  };
            var translationCountryAustriaEn = new Translation
                                                  {
                                                      Text = "Austria",
                                                      Language = english
                                                  };
            var translationCountryAzerbaijanEn = new Translation
                                                     {
                                                         Text = "Azerbaijann",
                                                         Language = english
                                                     };
            var translationCountryBelarusEn = new Translation
                                                  {
                                                      Text = "Belarus",
                                                      Language = english
                                                  };
            var translationCountryBelgiumEn = new Translation
                                                  {
                                                      Text = "Belgium",
                                                      Language = english
                                                  };
            var translationCountryBosniaHerzegovinaEn = new Translation
                                                            {
                                                                Text = "Bosnia and Herzegovina",
                                                                Language = english
                                                            };
            var translationCountryBulgariaEn = new Translation
                                                   {
                                                       Text = "Bulgaria",
                                                       Language = english
                                                   };
            var translationCountryCroatiaEn = new Translation
                                                  {
                                                      Text = "Croatia",
                                                      Language = english
                                                  };
            var translationCountryCyprusEn = new Translation
                                                 {
                                                     Text = "Cyprus",
                                                     Language = english
                                                 };
            var translationCountryCzechRepublicEn = new Translation
                                                        {
                                                            Text = "Czech Republic",
                                                            Language = english
                                                        };
            var translationCountryDenmarkEn = new Translation
                                                  {
                                                      Text = "Denmark",
                                                      Language = english
                                                  };
            var translationCountryEstoniaEn = new Translation
                                                  {
                                                      Text = "Estonia",
                                                      Language = english
                                                  };
            var translationCountryFinlandEn = new Translation
                                                  {
                                                      Text = "Finland",
                                                      Language = english
                                                  };
            var translationCountryFranceEn = new Translation
                                                 {
                                                     Text = "France",
                                                     Language = english
                                                 };
            var translationCountryGeorgiaEn = new Translation
                                                  {
                                                      Text = "Georgia",
                                                      Language = english
                                                  };
            var translationCountryGermanyEn = new Translation
                                                  {
                                                      Text = "Germany",
                                                      Language = english
                                                  };
            var translationCountryGreeceEn = new Translation
                                                 {
                                                     Text = "Greece",
                                                     Language = english
                                                 };
            var translationCountryHungaryEn = new Translation
                                                  {
                                                      Text = "Hungary",
                                                      Language = english
                                                  };
            var translationCountryIcelandEn = new Translation
                                                  {
                                                      Text = "Iceland",
                                                      Language = english
                                                  };
            var translationCountryIrelandEn = new Translation
                                                  {
                                                      Text = "Ireland",
                                                      Language = english
                                                  };
            var translationCountryItalyEn = new Translation
                                                {
                                                    Text = "Italy",
                                                    Language = english
                                                };
            var translationCountryKosovoEn = new Translation
                                                 {
                                                     Text = "Kosovo",
                                                     Language = english
                                                 };
            var translationCountryLatviaEn = new Translation
                                                 {
                                                     Text = "Latvia",
                                                     Language = english
                                                 };
            var translationCountryLiechtensteinEn = new Translation
                                                        {
                                                            Text = "Liechtenstein",
                                                            Language = english
                                                        };
            var translationCountryLithuaniaEn = new Translation
                                                    {
                                                        Text = "Lithuania",
                                                        Language = english
                                                    };
            var translationCountryLuxembourgEn = new Translation
                                                     {
                                                         Text = "Luxembourg",
                                                         Language = english
                                                     };
            var translationCountryMacedoniaEn = new Translation
                                                    {
                                                        Text = "Macedonia",
                                                        Language = english
                                                    };
            var translationCountryMaltaEn = new Translation
                                                {
                                                    Text = "Malta",
                                                    Language = english
                                                };
            var translationCountryMoldovaEn = new Translation
                                                  {
                                                      Text = "Moldova",
                                                      Language = english
                                                  };
            var translationCountryMonacoEn = new Translation
                                                 {
                                                     Text = "Monaco",
                                                     Language = english
                                                 };
            var translationCountryMontenegroEn = new Translation
                                                     {
                                                         Text = "Montenegro",
                                                         Language = english
                                                     };
            var translationCountryNetherlandsEn = new Translation
                                                      {
                                                          Text = "Netherlands",
                                                          Language = english
                                                      };
            var translationCountryNorwayEn = new Translation
                                                 {
                                                     Text = "Norway",
                                                     Language = english
                                                 };
            var translationCountryPolandEn = new Translation
                                                 {
                                                     Text = "Poland",
                                                     Language = english
                                                 };
            var translationCountryPortugalEn = new Translation
                                                   {
                                                       Text = "Portugal",
                                                       Language = english
                                                   };
            var translationCountryRomaniaEn = new Translation
                                                  {
                                                      Text = "Romania",
                                                      Language = english
                                                  };
            var translationCountryRussiaEn = new Translation
                                                 {
                                                     Text = "Russia",
                                                     Language = english
                                                 };
            var translationCountrySanMarinoEn = new Translation
                                                    {
                                                        Text = "San Marino",
                                                        Language = english
                                                    };
            var translationCountrySerbiaEn = new Translation
                                                 {
                                                     Text = "Serbia",
                                                     Language = english
                                                 };
            var translationCountrySlovakiaEn = new Translation
                                                   {
                                                       Text = "Slovakia",
                                                       Language = english
                                                   };
            var translationCountrySloveniaEn = new Translation
                                                   {
                                                       Text = "Slovenia",
                                                       Language = english
                                                   };
            var translationCountrySpainEn = new Translation
                                                {
                                                    Text = "Spain",
                                                    Language = english
                                                };
            var translationCountrySwedenEn = new Translation
                                                 {
                                                     Text = "Sweden",
                                                     Language = english
                                                 };
            var translationCountrySwitzerlandEn = new Translation
                                                      {
                                                          Text = "Switzerland",
                                                          Language = english
                                                      };
            var translationCountryTurkeyEn = new Translation
                                                 {
                                                     Text = "Turkey",
                                                     Language = english
                                                 };
            var translationCountryUkraineEn = new Translation
                                                  {
                                                      Text = "Ukraine",
                                                      Language = english
                                                  };
            var translationCountryUnitedKingdomEn = new Translation
                                                        {
                                                            Text = "United Kingdom",
                                                            Language = english
                                                        };
            var translationCountryVaticanCityEn = new Translation
                                                      {
                                                          Text = "Vatican City",
                                                          Language = english
                                                      };
            //German
            var translationCountryAlbaniaDe = new Translation
                                                  {
                                                      Text = "Albanien",
                                                      Language = german
                                                  };
            var translationCountryAndorraDe = new Translation
                                                  {
                                                      Text = "Andorra",
                                                      Language = german
                                                  };
            var translationCountryArmeniaDe = new Translation
                                                  {
                                                      Text = "Armenien",
                                                      Language = german
                                                  };
            var translationCountryAustriaDe = new Translation
                                                  {
                                                      Text = "Österreich",
                                                      Language = german
                                                  };
            var translationCountryAzerbaijanDe = new Translation
                                                     {
                                                         Text = "Aserbaidschan",
                                                         Language = german
                                                     };
            var translationCountryBelarusDe = new Translation
                                                  {
                                                      Text = "Weißrussland",
                                                      Language = german
                                                  };
            var translationCountryBelgiumDe = new Translation
                                                  {
                                                      Text = "Belgien",
                                                      Language = german
                                                  };
            var translationCountryBosniaHerzegovinaDe = new Translation
                                                            {
                                                                Text = "Bosnien und Herzegowina",
                                                                Language = german
                                                            };
            var translationCountryBulgariaDe = new Translation
                                                   {
                                                       Text = "Bulgarien",
                                                       Language = german
                                                   };
            var translationCountryCroatiaDe = new Translation
                                                  {
                                                      Text = "Kroatien",
                                                      Language = german
                                                  };
            var translationCountryCyprusDe = new Translation
                                                 {
                                                     Text = "Zypern",
                                                     Language = german
                                                 };
            var translationCountryCzechRepublicDe = new Translation
                                                        {
                                                            Text = "Tschechische Republik",
                                                            Language = german
                                                        };
            var translationCountryDenmarkDe = new Translation
                                                  {
                                                      Text = "Dänemark",
                                                      Language = german
                                                  };
            var translationCountryEstoniaDe = new Translation
                                                  {
                                                      Text = "Estland",
                                                      Language = german
                                                  };
            var translationCountryFinlandDe = new Translation
                                                  {
                                                      Text = "Finnland",
                                                      Language = german
                                                  };
            var translationCountryFranceDe = new Translation
                                                 {
                                                     Text = "Frankreich",
                                                     Language = german
                                                 };
            var translationCountryGeorgiaDe = new Translation
                                                  {
                                                      Text = "Georgia",
                                                      Language = german
                                                  };
            var translationCountryGermanyDe = new Translation
                                                  {
                                                      Text = "Deutschland",
                                                      Language = german
                                                  };
            var translationCountryGreeceDe = new Translation
                                                 {
                                                     Text = "Griechenland",
                                                     Language = german
                                                 };
            var translationCountryHungaryDe = new Translation
                                                  {
                                                      Text = "Ungarn",
                                                      Language = german
                                                  };
            var translationCountryIcelandDe = new Translation
                                                  {
                                                      Text = "Island",
                                                      Language = german
                                                  };
            var translationCountryIrelandDe = new Translation
                                                  {
                                                      Text = "Irland",
                                                      Language = german
                                                  };
            var translationCountryItalyDe = new Translation
                                                {
                                                    Text = "Italien",
                                                    Language = german
                                                };
            var translationCountryKosovoDe = new Translation
                                                 {
                                                     Text = "Kosovo",
                                                     Language = german
                                                 };
            var translationCountryLatviaDe = new Translation
                                                 {
                                                     Text = "Lettland",
                                                     Language = german
                                                 };
            var translationCountryLiechtensteinDe = new Translation
                                                        {
                                                            Text = "Liechtenstein",
                                                            Language = german
                                                        };
            var translationCountryLithuaniaDe = new Translation
                                                    {
                                                        Text = "Litauen",
                                                        Language = german
                                                    };
            var translationCountryLuxembourgDe = new Translation
                                                     {
                                                         Text = "Luxemburg",
                                                         Language = german
                                                     };
            var translationCountryMacedoniaDe = new Translation
                                                    {
                                                        Text = "Mazedonien",
                                                        Language = german
                                                    };
            var translationCountryMaltaDe = new Translation
                                                {
                                                    Text = "Malta",
                                                    Language = german
                                                };
            var translationCountryMoldovaDe = new Translation
                                                  {
                                                      Text = "Moldawien",
                                                      Language = german
                                                  };
            var translationCountryMonacoDe = new Translation
                                                 {
                                                     Text = "Monaco",
                                                     Language = german
                                                 };
            var translationCountryMontenegroDe = new Translation
                                                     {
                                                         Text = "Montenegro",
                                                         Language = german
                                                     };
            var translationCountryNetherlandsDe = new Translation
                                                      {
                                                          Text = "Niederlande",
                                                          Language = german
                                                      };
            var translationCountryNorwayDe = new Translation
                                                 {
                                                     Text = "Norwegen",
                                                     Language = german
                                                 };
            var translationCountryPolandDe = new Translation
                                                 {
                                                     Text = "Polen",
                                                     Language = german
                                                 };
            var translationCountryPortugalDe = new Translation
                                                   {
                                                       Text = "Portugal",
                                                       Language = german
                                                   };
            var translationCountryRomaniaDe = new Translation
                                                  {
                                                      Text = "Rumänien",
                                                      Language = german
                                                  };
            var translationCountryRussiaDe = new Translation
                                                 {
                                                     Text = "Russland",
                                                     Language = german
                                                 };
            var translationCountrySanMarinoDe = new Translation
                                                    {
                                                        Text = "San Marino",
                                                        Language = german
                                                    };
            var translationCountrySerbiaDe = new Translation
                                                 {
                                                     Text = "Serbien",
                                                     Language = german
                                                 };
            var translationCountrySlovakiaDe = new Translation
                                                   {
                                                       Text = "Slowakei",
                                                       Language = german
                                                   };
            var translationCountrySloveniaDe = new Translation
                                                   {
                                                       Text = "Slowenien",
                                                       Language = german
                                                   };
            var translationCountrySpainDe = new Translation
                                                {
                                                    Text = "Spanien",
                                                    Language = german
                                                };
            var translationCountrySwedenDe = new Translation
                                                 {
                                                     Text = "Schweden",
                                                     Language = german
                                                 };
            var translationCountrySwitzerlandDe = new Translation
                                                      {
                                                          Text = "Schweiz",
                                                          Language = german
                                                      };
            var translationCountryTurkeyDe = new Translation
                                                 {
                                                     Text = "Türkei",
                                                     Language = german
                                                 };
            var translationCountryUkraineDe = new Translation
                                                  {
                                                      Text = "Ukraine",
                                                      Language = german
                                                  };
            var translationCountryUnitedKingdomDe = new Translation
                                                        {
                                                            Text = "Vereinigtes Königreich",
                                                            Language = german
                                                        };
            var translationCountryVaticanCityDe = new Translation
                                                      {
                                                          Text = "Vatikanstadt",
                                                          Language = german
                                                      };
            //Croatian
            var translationCountryAlbaniaHr = new Translation
                                                  {
                                                      Text = "Albanija",
                                                      Language = croatian
                                                  };
            var translationCountryAndorraHr = new Translation
                                                  {
                                                      Text = "Andora",
                                                      Language = croatian
                                                  };
            var translationCountryArmeniaHr = new Translation
                                                  {
                                                      Text = "Armenija",
                                                      Language = croatian
                                                  };
            var translationCountryAustriaHr = new Translation
                                                  {
                                                      Text = "Austrija",
                                                      Language = croatian
                                                  };
            var translationCountryAzerbaijanHr = new Translation
                                                     {
                                                         Text = "Azerbejdžan",
                                                         Language = croatian
                                                     };
            var translationCountryBelarusHr = new Translation
                                                  {
                                                      Text = "Bjelorusija",
                                                      Language = croatian
                                                  };
            var translationCountryBelgiumHr = new Translation
                                                  {
                                                      Text = "Belgija",
                                                      Language = croatian
                                                  };
            var translationCountryBosniaHerzegovinaHr = new Translation
                                                            {
                                                                Text = "Bosna i Hercegovina",
                                                                Language = croatian
                                                            };
            var translationCountryBulgariaHr = new Translation
                                                   {
                                                       Text = "Bugarska",
                                                       Language = croatian
                                                   };
            var translationCountryCroatiaHr = new Translation
                                                  {
                                                      Text = "Hrvatska",
                                                      Language = croatian
                                                  };
            var translationCountryCyprusHr = new Translation
                                                 {
                                                     Text = "Kipar",
                                                     Language = croatian
                                                 };
            var translationCountryCzechRepublicHr = new Translation
                                                        {
                                                            Text = "Češka",
                                                            Language = croatian
                                                        };
            var translationCountryDenmarkHr = new Translation
                                                  {
                                                      Text = "Danska",
                                                      Language = croatian
                                                  };
            var translationCountryEstoniaHr = new Translation
                                                  {
                                                      Text = "Estonija",
                                                      Language = croatian
                                                  };
            var translationCountryFinlandHr = new Translation
                                                  {
                                                      Text = "Finska",
                                                      Language = croatian
                                                  };
            var translationCountryFranceHr = new Translation
                                                 {
                                                     Text = "Francuska",
                                                     Language = croatian
                                                 };
            var translationCountryGeorgiaHr = new Translation
                                                  {
                                                      Text = "Gruzija",
                                                      Language = croatian
                                                  };
            var translationCountryGermanyHr = new Translation
                                                  {
                                                      Text = "Njemačka",
                                                      Language = croatian
                                                  };
            var translationCountryGreeceHr = new Translation
                                                 {
                                                     Text = "Grčka",
                                                     Language = croatian
                                                 };
            var translationCountryHungaryHr = new Translation
                                                  {
                                                      Text = "Madžarska",
                                                      Language = croatian
                                                  };
            var translationCountryIcelandHr = new Translation
                                                  {
                                                      Text = "Island",
                                                      Language = croatian
                                                  };
            var translationCountryIrelandHr = new Translation
                                                  {
                                                      Text = "Irska",
                                                      Language = croatian
                                                  };
            var translationCountryItalyHr = new Translation
                                                {
                                                    Text = "Italija",
                                                    Language = croatian
                                                };
            var translationCountryKosovoHr = new Translation
                                                 {
                                                     Text = "Kosovo",
                                                     Language = croatian
                                                 };
            var translationCountryLatviaHr = new Translation
                                                 {
                                                     Text = "Letonija",
                                                     Language = croatian
                                                 };
            var translationCountryLiechtensteinHr = new Translation
                                                        {
                                                            Text = "Lihtenštajn",
                                                            Language = croatian
                                                        };
            var translationCountryLithuaniaHr = new Translation
                                                    {
                                                        Text = "Litvanija",
                                                        Language = croatian
                                                    };
            var translationCountryLuxembourgHr = new Translation
                                                     {
                                                         Text = "Luksemburg",
                                                         Language = croatian
                                                     };
            var translationCountryMacedoniaHr = new Translation
                                                    {
                                                        Text = "Makedonija",
                                                        Language = croatian
                                                    };
            var translationCountryMaltaHr = new Translation
                                                {
                                                    Text = "Malta",
                                                    Language = croatian
                                                };
            var translationCountryMoldovaHr = new Translation
                                                  {
                                                      Text = "Moldavija",
                                                      Language = croatian
                                                  };
            var translationCountryMonacoHr = new Translation
                                                 {
                                                     Text = "Monaco",
                                                     Language = croatian
                                                 };
            var translationCountryMontenegroHr = new Translation
                                                     {
                                                         Text = "Crna Gora",
                                                         Language = croatian
                                                     };
            var translationCountryNetherlandsHr = new Translation
                                                      {
                                                          Text = "Holandija",
                                                          Language = croatian
                                                      };
            var translationCountryNorwayHr = new Translation
                                                 {
                                                     Text = "Norveška",
                                                     Language = croatian
                                                 };
            var translationCountryPolandHr = new Translation
                                                 {
                                                     Text = "Poljska",
                                                     Language = croatian
                                                 };
            var translationCountryPortugalHr = new Translation
                                                   {
                                                       Text = "Portugalija",
                                                       Language = croatian
                                                   };
            var translationCountryRomaniaHr = new Translation
                                                  {
                                                      Text = "Rumunija",
                                                      Language = croatian
                                                  };
            var translationCountryRussiaHr = new Translation
                                                 {
                                                     Text = "Rusija",
                                                     Language = croatian
                                                 };
            var translationCountrySanMarinoHr = new Translation
                                                    {
                                                        Text = "San Marino",
                                                        Language = croatian
                                                    };
            var translationCountrySerbiaHr = new Translation
                                                 {
                                                     Text = "Srbija",
                                                     Language = croatian
                                                 };
            var translationCountrySlovakiaHr = new Translation
                                                   {
                                                       Text = "Slovačka",
                                                       Language = croatian
                                                   };
            var translationCountrySloveniaHr = new Translation
                                                   {
                                                       Text = "Slovenija",
                                                       Language = croatian
                                                   };
            var translationCountrySpainHr = new Translation
                                                {
                                                    Text = "Španjolska",
                                                    Language = croatian
                                                };
            var translationCountrySwedenHr = new Translation
                                                 {
                                                     Text = "Švedska",
                                                     Language = croatian
                                                 };
            var translationCountrySwitzerlandHr = new Translation
                                                      {
                                                          Text = "Švajcarska",
                                                          Language = croatian
                                                      };
            var translationCountryTurkeyHr = new Translation
                                                 {
                                                     Text = "Turska",
                                                     Language = croatian
                                                 };
            var translationCountryUkraineHr = new Translation
                                                  {
                                                      Text = "Ukrajina",
                                                      Language = croatian
                                                  };
            var translationCountryUnitedKingdomHr = new Translation
                                                        {
                                                            Text = "Ujedinjeno Kraljevstvo",
                                                            Language = croatian
                                                        };
            var translationCountryVaticanCityHr = new Translation
                                                      {
                                                          Text = "Vatikan",
                                                          Language = croatian
                                                      };

            new List<Translation>
                {
                    translationIndustryEducationTitleEn,
                    translationIndustryEducationTitleDe,
                    translationIndustryEducationTitleHr,
                    translationIndustryInformationTitleEn,
                    translationIndustryInformationTitleDe,
                    translationIndustryInformationTitleHr,
                    //Country Translations
                    translationCountryAlbaniaEn,
                    translationCountryAndorraEn,
                    translationCountryArmeniaEn,
                    translationCountryAustriaEn,
                    translationCountryAzerbaijanEn,
                    translationCountryBelarusEn,
                    translationCountryBelgiumEn,
                    translationCountryBosniaHerzegovinaEn,
                    translationCountryBulgariaEn,
                    translationCountryCroatiaEn,
                    translationCountryCyprusEn,
                    translationCountryCzechRepublicEn,
                    translationCountryDenmarkEn,
                    translationCountryEstoniaEn,
                    translationCountryFinlandEn,
                    translationCountryFranceEn,
                    translationCountryGeorgiaEn,
                    translationCountryGermanyEn,
                    translationCountryGreeceEn,
                    translationCountryHungaryEn,
                    translationCountryIcelandEn,
                    translationCountryIrelandEn,
                    translationCountryItalyEn,
                    translationCountryKosovoEn,
                    translationCountryLatviaEn,
                    translationCountryLiechtensteinEn,
                    translationCountryLithuaniaEn,
                    translationCountryLuxembourgEn,
                    translationCountryMacedoniaEn,
                    translationCountryMaltaEn,
                    translationCountryMoldovaEn,
                    translationCountryMonacoEn,
                    translationCountryMontenegroEn,
                    translationCountryNetherlandsEn,
                    translationCountryNorwayEn,
                    translationCountryPolandEn,
                    translationCountryPortugalEn,
                    translationCountryRomaniaEn,
                    translationCountryRussiaEn,
                    translationCountrySanMarinoEn,
                    translationCountrySerbiaEn,
                    translationCountrySlovakiaEn,
                    translationCountrySloveniaEn,
                    translationCountrySpainEn,
                    translationCountrySwedenEn,
                    translationCountrySwitzerlandEn,
                    translationCountryTurkeyEn,
                    translationCountryUkraineEn,
                    translationCountryUnitedKingdomEn,
                    translationCountryVaticanCityEn,
                    translationCountryAlbaniaDe,
                    translationCountryAndorraDe,
                    translationCountryArmeniaDe,
                    translationCountryAustriaDe,
                    translationCountryAzerbaijanDe,
                    translationCountryBelarusDe,
                    translationCountryBelgiumDe,
                    translationCountryBosniaHerzegovinaDe,
                    translationCountryBulgariaDe,
                    translationCountryCroatiaDe,
                    translationCountryCyprusDe,
                    translationCountryCzechRepublicDe,
                    translationCountryDenmarkDe,
                    translationCountryEstoniaDe,
                    translationCountryFinlandDe,
                    translationCountryFranceDe,
                    translationCountryGeorgiaDe,
                    translationCountryGermanyDe,
                    translationCountryGreeceDe,
                    translationCountryHungaryDe,
                    translationCountryIcelandDe,
                    translationCountryIrelandDe,
                    translationCountryItalyDe,
                    translationCountryKosovoDe,
                    translationCountryLatviaDe,
                    translationCountryLiechtensteinDe,
                    translationCountryLithuaniaDe,
                    translationCountryLuxembourgDe,
                    translationCountryMacedoniaDe,
                    translationCountryMaltaDe,
                    translationCountryMoldovaDe,
                    translationCountryMonacoDe,
                    translationCountryMontenegroDe,
                    translationCountryNetherlandsDe,
                    translationCountryNorwayDe,
                    translationCountryPolandDe,
                    translationCountryPortugalDe,
                    translationCountryRomaniaDe,
                    translationCountryRussiaDe,
                    translationCountrySanMarinoDe,
                    translationCountrySerbiaDe,
                    translationCountrySlovakiaDe,
                    translationCountrySloveniaDe,
                    translationCountrySpainDe,
                    translationCountrySwedenDe,
                    translationCountrySwitzerlandDe,
                    translationCountryTurkeyDe,
                    translationCountryUkraineDe,
                    translationCountryUnitedKingdomDe,
                    translationCountryVaticanCityDe,
                    translationCountryAlbaniaHr,
                    translationCountryAndorraHr,
                    translationCountryArmeniaHr,
                    translationCountryAustriaHr,
                    translationCountryAzerbaijanHr,
                    translationCountryBelarusHr,
                    translationCountryBelgiumHr,
                    translationCountryBosniaHerzegovinaHr,
                    translationCountryBulgariaHr,
                    translationCountryCroatiaHr,
                    translationCountryCyprusHr,
                    translationCountryCzechRepublicHr,
                    translationCountryDenmarkHr,
                    translationCountryEstoniaHr,
                    translationCountryFinlandHr,
                    translationCountryFranceHr,
                    translationCountryGeorgiaHr,
                    translationCountryGermanyHr,
                    translationCountryGreeceHr,
                    translationCountryHungaryHr,
                    translationCountryIcelandHr,
                    translationCountryIrelandHr,
                    translationCountryItalyHr,
                    translationCountryKosovoHr,
                    translationCountryLatviaHr,
                    translationCountryLiechtensteinHr,
                    translationCountryLithuaniaHr,
                    translationCountryLuxembourgHr,
                    translationCountryMacedoniaHr,
                    translationCountryMaltaHr,
                    translationCountryMoldovaHr,
                    translationCountryMonacoHr,
                    translationCountryMontenegroHr,
                    translationCountryNetherlandsHr,
                    translationCountryNorwayHr,
                    translationCountryPolandHr,
                    translationCountryPortugalHr,
                    translationCountryRomaniaHr,
                    translationCountryRussiaHr,
                    translationCountrySanMarinoHr,
                    translationCountrySerbiaHr,
                    translationCountrySlovakiaHr,
                    translationCountrySloveniaHr,
                    translationCountrySpainHr,
                    translationCountrySwedenHr,
                    translationCountrySwitzerlandHr,
                    translationCountryTurkeyHr,
                    translationCountryUkraineHr,
                    translationCountryUnitedKingdomHr,
                    translationCountryVaticanCityHr
                }.ForEach(t => context.Translations.AddOrUpdate(t));


            // INDUSTRIES
            var educationIndustry = new Industry
                                        {
                                            Key = "Industry/Education",
                                            Description = "Education",
                                        };

            var informationAndCommunicationIndustry = new Industry
                                                          {
                                                              Key = "Industry/Information and Communication",
                                                              Description = "Information and Communication",
                                                          };

            var creativeIndustry = new Industry
                                       {
                                           Key = "Industry/Creative",
                                           Description = "Creative",
                                       };
            new List<Industry>
                {
                    educationIndustry,
                    informationAndCommunicationIndustry,
                    creativeIndustry
                }.ForEach(i => context.Industries.AddOrUpdate(i));

            //CATEGORIES OF INDUSTRY EDUCATION
            var prePrimaryEducation = new Category
                                          {
                                              Key = "Pre-primary and primary education",
                                              Description = "Pre-primary and primary education",
                                              ParentCategory = null,
                                              Industry = educationIndustry
                                          };
            var secondaryEducation = new Category
                                         {
                                             Key = "Secondary education",
                                             Description = "Secondary educationn",
                                             ParentCategory = null,
                                             Industry = educationIndustry
                                         };
            var higherEducation = new Category
                                      {
                                          Key = "Higher education",
                                          Description = "Higher education",
                                          ParentCategory = null,
                                          Industry = educationIndustry
                                      };
            var otherEducation = new Category
                                     {
                                         Key = "Other education",
                                         Description = "Other education",
                                         ParentCategory = null,
                                         Industry = educationIndustry
                                     };
            var supportActivitiesEducation = new Category
                                                 {
                                                     Key = "Educational support activities",
                                                     Description = "Educational support activities",
                                                     ParentCategory = null,
                                                     Industry = educationIndustry
                                                 };
            //CATEGORIES OF INDUSTRY INFORMATION AND COMMUNICATION
            var publishingActivities = new Category
                                           {
                                               Key = "Publishing activities",
                                               Description = "Publishing activities",
                                               ParentCategory = null,
                                               Industry = informationAndCommunicationIndustry
                                           };
            var motionPicture = new Category
                                    {
                                        Key =
                                            "Motion picture, video and television programme production, sound recording and music publishing activities",
                                        Description =
                                            "Motion picture, video and television programme production, sound recording and music publishing activities",
                                        ParentCategory = null,
                                        Industry = informationAndCommunicationIndustry
                                    };
            var programmingBroadcasting = new Category
                                              {
                                                  Key = "Programming and broadcasting activities",
                                                  Description = "Programming and broadcasting activities",
                                                  ParentCategory = null,
                                                  Industry = informationAndCommunicationIndustry
                                              };
            var telecommunications = new Category
                                         {
                                             Key = "Telecommunications",
                                             Description = "Telecommunications",
                                             ParentCategory = null,
                                             Industry = informationAndCommunicationIndustry
                                         };
            var computerProgramming = new Category
                                          {
                                              Key = "Computer programming, consultancy and related activities",
                                              Description = "Computer programming, consultancy and related activities",
                                              ParentCategory = null,
                                              Industry = informationAndCommunicationIndustry
                                          };
            var informationService = new Category
                                         {
                                             Key = "Information service activities",
                                             Description = "Information service activities",
                                             ParentCategory = null,
                                             Industry = informationAndCommunicationIndustry
                                         };
            //Publishing activities ->
            var bookPublishing = new Category
                                     {
                                         Key = "Book publishing",
                                         Description = "Book publishing",
                                         ParentCategory = publishingActivities,
                                         Industry = informationAndCommunicationIndustry
                                     };
            var publishingDirectories = new Category
                                            {
                                                Key = "Publishing of directories and mailing lists",
                                                Description = "Publishing of directories and mailing lists",
                                                ParentCategory = publishingActivities,
                                                Industry = informationAndCommunicationIndustry
                                            };
            var publishingNewspapers = new Category
                                           {
                                               Key = "Publishing of newspapers, journals and periodicals",
                                               Description = "Publishing of newspapers, journals and periodicals",
                                               ParentCategory = publishingActivities,
                                               Industry = informationAndCommunicationIndustry
                                           };
            var otherPublishing = new Category
                                      {
                                          Key = "Other publishing activities",
                                          Description = "Other publishing activities",
                                          ParentCategory = publishingActivities,
                                          Industry = informationAndCommunicationIndustry
                                      };
            var softwarePublishing = new Category
                                         {
                                             Key = "Software publishing",
                                             Description = "Software publishing",
                                             ParentCategory = publishingActivities,
                                             Industry = informationAndCommunicationIndustry
                                         };
            //Motion picture ->
            var motionPictureProductionActivities = new Category
                                                        {
                                                            Key =
                                                                "Motion picture, video and television programme production activities",
                                                            Description =
                                                                "Motion picture, video and television programme production activities",
                                                            ParentCategory = motionPicture,
                                                            Industry = informationAndCommunicationIndustry
                                                        };
            var motionPicturePostProductionActivities = new Category
                                                            {
                                                                Key =
                                                                    "Motion picture, video and television programme post-production activities",
                                                                Description =
                                                                    "Motion picture, video and television programme post-production activities",
                                                                ParentCategory = motionPicture,
                                                                Industry = informationAndCommunicationIndustry
                                                            };
            var motionPictureDistributionActivities = new Category
                                                          {
                                                              Key =
                                                                  "Motion picture, video and television programme distribution activities",
                                                              Description =
                                                                  "Motion picture, video and television programme distribution activities",
                                                              ParentCategory = motionPicture,
                                                              Industry = informationAndCommunicationIndustry
                                                          };
            var motionPictureProjectionActivities = new Category
                                                        {
                                                            Key = "Motion picture projection activities",
                                                            Description = "Motion picture projection activities",
                                                            ParentCategory = motionPicture,
                                                            Industry = informationAndCommunicationIndustry
                                                        };
            var soundRecording = new Category
                                     {
                                         Key = "Sound recording and music publishing activities",
                                         Description = "Sound recording and music publishing activities",
                                         ParentCategory = motionPicture,
                                         Industry = informationAndCommunicationIndustry
                                     };
            //Programming broadcasting ->
            var radioBroadcasting = new Category
                                        {
                                            Key = "Radio broadcasting",
                                            Description = "Radio broadcasting",
                                            ParentCategory = programmingBroadcasting,
                                            Industry = informationAndCommunicationIndustry
                                        };
            var tvProgramming = new Category
                                    {
                                        Key = "Television programming and broadcasting activitiesg",
                                        Description = "Television programming and broadcasting activities",
                                        ParentCategory = programmingBroadcasting,
                                        Industry = informationAndCommunicationIndustry
                                    };
            //Telecommunications ->
            var wiredTelActivities = new Category
                                         {
                                             Key = "Wired telecommunications activities",
                                             Description = "Wired telecommunications activities",
                                             ParentCategory = telecommunications,
                                             Industry = informationAndCommunicationIndustry
                                         };
            var wirelessTelActivities = new Category
                                            {
                                                Key = "Wireless telecommunications activities",
                                                Description = "Wireless telecommunications activities",
                                                ParentCategory = telecommunications,
                                                Industry = informationAndCommunicationIndustry
                                            };
            var satelliteTelActivities = new Category
                                             {
                                                 Key = "Satellite telecommunications activities",
                                                 Description = "Satellite telecommunications activities",
                                                 ParentCategory = telecommunications,
                                                 Industry = informationAndCommunicationIndustry
                                             };
            var otherTelActivities = new Category
                                         {
                                             Key = "Other telecommunications activities",
                                             Description = "Other telecommunications activities",
                                             ParentCategory = telecommunications,
                                             Industry = informationAndCommunicationIndustry
                                         };
            //Computer Programming ->
            var comProgrammingActivities = new Category
                                               {
                                                   Key = "Computer programming activities",
                                                   Description = "Computer programming activities",
                                                   ParentCategory = computerProgramming,
                                                   Industry = informationAndCommunicationIndustry
                                               };
            var comConsultancy = new Category
                                     {
                                         Key = "Computer consultancy and computer facilities management activities",
                                         Description =
                                             "Computer consultancy and computer facilities management activities",
                                         ParentCategory = computerProgramming,
                                         Industry = informationAndCommunicationIndustry
                                     };
            var otherIT = new Category
                              {
                                  Key = "Other information technology and computer service activities",
                                  Description = "Other information technology and computer service activities",
                                  ParentCategory = computerProgramming,
                                  Industry = informationAndCommunicationIndustry
                              };
            //Information Service ->
            var dataProcessing = new Category
                                     {
                                         Key = "Data processing, hosting and related activities",
                                         Description = "Data processing, hosting and related activities",
                                         ParentCategory = informationService,
                                         Industry = informationAndCommunicationIndustry
                                     };
            var webPortals = new Category
                                 {
                                     Key = "Web portals",
                                     Description = "Web portals",
                                     ParentCategory = informationService,
                                     Industry = informationAndCommunicationIndustry
                                 };
            var newsAgencyActivities = new Category
                                           {
                                               Key = "News agency activities",
                                               Description = "News agency activities",
                                               ParentCategory = informationService,
                                               Industry = informationAndCommunicationIndustry
                                           };
            var otherInformationService = new Category
                                              {
                                                  Key = "Other information service activities nec",
                                                  Description = "Other information service activities nec",
                                                  ParentCategory = informationService,
                                                  Industry = informationAndCommunicationIndustry
                                              };

            #region

            //CATEGORIES
            var AdministrationSupport = new Category
                                            {
                                                Key = "Administration/Support",
                                                Description = "Administration/Support",
                                                ParentCategory = null,
                                                Industry = educationIndustry
                                            };
            var ArchitectureDesign = new Category
                                         {
                                             Key = "Architecture/Design",
                                             Description = "Architecture/Design",
                                             ParentCategory = null,
                                             Industry = educationIndustry
                                         };
            var BusinessAnalysisConsulting = new Category
                                                 {
                                                     Key = "Business analysis/Consulting",
                                                     Description = "Business analysis/Consulting",
                                                     ParentCategory = null,
                                                     Industry = educationIndustry
                                                 };
            var InterdisciplinaryRoles = new Category
                                             {
                                                 Key = "Interdisciplinary roles",
                                                 Description = "Interdisciplinary roles",
                                                 ParentCategory = null,
                                                 Industry = educationIndustry
                                             };
            var ManagementIT = new Category
                                   {
                                       Key = "Management IT",
                                       Description = "Management IT",
                                       ParentCategory = null,
                                       Industry = educationIndustry
                                   };
            var Network = new Category
                              {
                                  Key = "Network",
                                  Description = "Network",
                                  ParentCategory = null,
                                  Industry = educationIndustry
                              };
            var QualityAssuranceTest = new Category
                                           {
                                               Key = "Quality assurance/Test",
                                               Description = "Quality assurance/Test",
                                               ParentCategory = null,
                                               Industry = educationIndustry
                                           };
            var SoftwareDevelopment = new Category
                                          {
                                              Key = "Software development",
                                              Description = "Software development",
                                              ParentCategory = null,
                                              Industry = educationIndustry
                                          };
            var Trainer = new Category
                              {
                                  Key = "Trainer",
                                  Description = "Trainer",
                                  ParentCategory = null,
                                  Industry = educationIndustry
                              };

            //Start->Administration/Support
            var ApplicationConsultant = new Category
                                            {
                                                Key = "Application consultant",
                                                Description = "Application consultant",
                                                ParentCategory = AdministrationSupport,
                                                Industry = educationIndustry
                                            };
            var DatabaseAdministrator = new Category

                                            {
                                                Key = "Database administrator",
                                                Description = "Database administrator",
                                                ParentCategory = AdministrationSupport,
                                                Industry = educationIndustry
                                            };
            var ITOperator = new Category
                                 {
                                     Key = "IT operator",
                                     Description = "IT operator",
                                     ParentCategory = AdministrationSupport,
                                     Industry = educationIndustry
                                 };
            var LinuxAdministrator = new Category
                                         {
                                             Key = "Linux administrator",
                                             Description = "Linux administrator",
                                             ParentCategory = AdministrationSupport,
                                             Industry = educationIndustry
                                         };
            var SAPAdministrator = new Category
                                       {
                                           Key = "SAP administrator",
                                           Description = "SAP administrator",
                                           ParentCategory = AdministrationSupport,
                                           Industry = educationIndustry
                                       };
            var UnixAdministrator = new Category
                                        {
                                            Key = "Unix administrator",
                                            Description = "Unix administrator",
                                            ParentCategory = AdministrationSupport,
                                            Industry = educationIndustry
                                        };
            var WindowsAdministrator = new Category
                                           {
                                               Key = "Windows administrator",
                                               Description = "Windows administrator",
                                               ParentCategory = AdministrationSupport,
                                               Industry = educationIndustry
                                           };
            var ApplicationServerAdministrator = new Category
                                                     {
                                                         Key = "Application server administrator",
                                                         Description = "Application server administrator",
                                                         ParentCategory = AdministrationSupport,
                                                         Industry = educationIndustry
                                                     };
            var HelpdeskSupport = new Category
                                      {
                                          Key = "Helpdesk/support",
                                          Description = "Helpdesk/support",
                                          ParentCategory = AdministrationSupport,
                                          Industry = educationIndustry
                                      };
            var ITTechnician = new Category
                                   {
                                       Key = "IT technician",
                                       Description = "IT technician",
                                       ParentCategory = AdministrationSupport,
                                       Industry = educationIndustry
                                   };
            var NetworkAdministrator = new Category
                                           {
                                               Key = "Network administrator",
                                               Description = "Network administrator",
                                               ParentCategory = AdministrationSupport,
                                               Industry = educationIndustry
                                           };
            var StorageAdministrator = new Category
                                           {
                                               Key = "Storage administrator",
                                               Description = "Storage administrator",
                                               ParentCategory = AdministrationSupport,
                                               Industry = educationIndustry
                                           };
            var Webmaster = new Category
                                {
                                    Key = "Webmaster",
                                    Description = "Webmaster",
                                    ParentCategory = AdministrationSupport,
                                    Industry = educationIndustry
                                };


            //Start->Architecture/Design
            var CapacityManager = new Category
                                      {
                                          Key = "Capacity manager",
                                          Description = "Capacity manager",
                                          ParentCategory = ArchitectureDesign,
                                          Industry = educationIndustry
                                      };
            var SystemArchitect = new Category
                                      {
                                          Key = "System architect",
                                          Description = "System architect",
                                          ParentCategory = ArchitectureDesign,
                                          Industry = educationIndustry
                                      };
            var SoftwareArchitect = new Category
                                        {
                                            Key = "Software architect",
                                            Description = "Software architect",
                                            ParentCategory = ArchitectureDesign,
                                            Industry = educationIndustry
                                        };
            var WebDesigner = new Category
                                  {
                                      Key = "Web designer",
                                      Description = "Web designer",
                                      ParentCategory = ArchitectureDesign,
                                      Industry = educationIndustry
                                  };

            //Start->Business analysis/Consulting
            var BIConsultant = new Category
                                   {
                                       Key = "BI consultant",
                                       Description = "BI consultant",
                                       ParentCategory = BusinessAnalysisConsulting,
                                       Industry = educationIndustry
                                   };
            var ChangeManager = new Category
                                    {
                                        Key = "Change manager",
                                        Description = "Change manager",
                                        ParentCategory = BusinessAnalysisConsulting,
                                        Industry = educationIndustry
                                    };
            var ITConsultant = new Category
                                   {
                                       Key = "IT consultant",
                                       Description = "IT consultant",
                                       ParentCategory = BusinessAnalysisConsulting,
                                       Industry = educationIndustry
                                   };
            var SystemAnalyst = new Category
                                    {
                                        Key = "System analyst",
                                        Description = "System analyst",
                                        ParentCategory = BusinessAnalysisConsulting,
                                        Industry = educationIndustry
                                    };
            var CRMConsultant = new Category
                                    {
                                        Key = "CRM consultant",
                                        Description = "CRM consultant",
                                        ParentCategory = BusinessAnalysisConsulting,
                                        Industry = educationIndustry
                                    };
            var ConsultantForTradingSystems = new Category
                                                  {
                                                      Key = "Consultant for trading systems",
                                                      Description = "Consultant for trading systems",
                                                      ParentCategory = BusinessAnalysisConsulting,
                                                      Industry = educationIndustry
                                                  };
            var SAPConsultant = new Category
                                    {
                                        Key = "SAP consultant",
                                        Description = "SAP consultant",
                                        ParentCategory = BusinessAnalysisConsulting,
                                        Industry = educationIndustry
                                    };

            //Start-> Interdisciplinary roles
            var Auditor = new Category
                              {
                                  Key = "Auditor",
                                  Description = "Auditor",
                                  ParentCategory = InterdisciplinaryRoles,
                                  Industry = educationIndustry
                              };
            var BusinessDevelopmentManager = new Category
                                                 {
                                                     Key = "Business development manager",
                                                     Description = "Business development manager",
                                                     ParentCategory = InterdisciplinaryRoles,
                                                     Industry = educationIndustry
                                                 };
            var DirectorBusinessDevelopment = new Category
                                                  {
                                                      Key = "Director business development",
                                                      Description = "Director business development",
                                                      ParentCategory = InterdisciplinaryRoles,
                                                      Industry = educationIndustry
                                                  };

            var ProgramManager = new Category
                                     {
                                         Key = "Program manager",
                                         Description = "Program manager",
                                         ParentCategory = InterdisciplinaryRoles,
                                         Industry = educationIndustry
                                     };
            var ProjectManager = new Category
                                     {
                                         Key = "Project manager",
                                         Description = "Project manager",
                                         ParentCategory = InterdisciplinaryRoles,
                                         Industry = educationIndustry
                                     };
            var QualityAssuranceProfessional = new Category
                                                   {
                                                       Key = "Quality assurance professional",
                                                       Description = "Quality assurance professional",
                                                       ParentCategory = InterdisciplinaryRoles,
                                                       Industry = educationIndustry
                                                   };
            var QualityManager = new Category
                                     {
                                         Key = "Quality manager",
                                         Description = "Quality manager",
                                         ParentCategory = InterdisciplinaryRoles,
                                         Industry = educationIndustry
                                     };
            var SubprojectManager = new Category
                                        {
                                            Key = "Subproject manager",
                                            Description = "Subproject manager",
                                            ParentCategory = InterdisciplinaryRoles,
                                            Industry = educationIndustry
                                        };
            var WorkPlanner = new Category
                                  {
                                      Key = "Work planner",
                                      Description = "Work planner",
                                      ParentCategory = InterdisciplinaryRoles,
                                      Industry = educationIndustry
                                  };
            var BusinessAnalyst = new Category
                                      {
                                          Key = "Business analyst",
                                          Description = "Business analyst",
                                          ParentCategory = InterdisciplinaryRoles,
                                          Industry = educationIndustry
                                      };
            var DataProtectionOfficer = new Category
                                            {
                                                Key = "Data protection officer",
                                                Description = "Data protection officer",
                                                ParentCategory = InterdisciplinaryRoles,
                                                Industry = educationIndustry
                                            };
            var ManagingDirector = new Category
                                       {
                                           Key = "Managing director",
                                           Description = "Managing director",
                                           ParentCategory = InterdisciplinaryRoles,
                                           Industry = educationIndustry
                                       };

            var ProjectAssistant = new Category
                                       {
                                           Key = "Project assistant",
                                           Description = "Project assistant",
                                           ParentCategory = InterdisciplinaryRoles,
                                           Industry = educationIndustry
                                       };
            var Purchaser = new Category
                                {
                                    Key = "Purchaser",
                                    Description = "Purchaser",
                                    ParentCategory = InterdisciplinaryRoles,
                                    Industry = educationIndustry
                                };
            var QualityManagementRepresentative = new Category
                                                      {
                                                          Key = "Quality management representative",
                                                          Description = "Quality management representative",
                                                          ParentCategory = InterdisciplinaryRoles,
                                                          Industry = educationIndustry
                                                      };
            var SharedServiceCenterSpecialist = new Category
                                                    {
                                                        Key = "Shared service center specialist",
                                                        Description = "Shared service center specialist",
                                                        ParentCategory = InterdisciplinaryRoles,
                                                        Industry = educationIndustry
                                                    };
            var TechnicalWriter = new Category
                                      {
                                          Key = "Technical writer",
                                          Description = "Technical writer",
                                          ParentCategory = InterdisciplinaryRoles,
                                          Industry = educationIndustry
                                      };

            //Start->Management IT
            var ITManager = new Category
                                {
                                    Key = "IT manager",
                                    Description = "IT manager",
                                    ParentCategory = ManagementIT,
                                    Industry = educationIndustry
                                };
            var ServiceLevelManager = new Category
                                          {
                                              Key = "Service level manager",
                                              Description = "Service level manager",
                                              ParentCategory = ManagementIT,
                                              Industry = educationIndustry
                                          };

            //Start->Network
            var ConfigurationManager = new Category
                                           {
                                               Key = "Configuration manager",
                                               Description = "Configuration manager",
                                               ParentCategory = Network,
                                               Industry = educationIndustry
                                           };
            var ITSecurityManager = new Category
                                        {
                                            Key = "IT security manager",
                                            Description = "IT security manager",
                                            ParentCategory = Network,
                                            Industry = educationIndustry
                                        };
            var NetworkPlanner = new Category
                                     {
                                         Key = "Network planner",
                                         Description = "Network planner",
                                         ParentCategory = Network,
                                         Industry = educationIndustry
                                     };
            var HeadOfComputerCenter = new Category
                                           {
                                               Key = "Head of computer center",
                                               Description = "Head of computer center",
                                               ParentCategory = Network,
                                               Industry = educationIndustry
                                           };
            var ITSystemElectronicsTechnician = new Category
                                                    {
                                                        Key = "IT system electronics technician",
                                                        Description = "IT system electronics technician",
                                                        ParentCategory = Network,
                                                        Industry = educationIndustry
                                                    };
            var SystemIntegrator = new Category
                                       {
                                           Key = "System integrator",
                                           Description = "System integrator",
                                           ParentCategory = Network,
                                           Industry = educationIndustry
                                       };

            //Start->Quality assurance/Test
            var ITAuditor = new Category
                                {
                                    Key = "IT auditor",
                                    Description = "IT auditor",
                                    ParentCategory = QualityAssuranceTest,
                                    Industry = educationIndustry
                                };
            var Tester = new Category
                             {
                                 Key = "Tester",
                                 Description = "Tester",
                                 ParentCategory = QualityAssuranceTest,
                                 Industry = educationIndustry
                             };
            var TestManager = new Category
                                  {
                                      Key = "Test manager",
                                      Description = "Test manager",
                                      ParentCategory = QualityAssuranceTest,
                                      Industry = educationIndustry
                                  };

            //Start->Software development
            var DatabaseDeveloper = new Category
                                        {
                                            Key = "Database developer",
                                            Description = "Database developer",
                                            ParentCategory = SoftwareDevelopment,
                                            Industry = educationIndustry
                                        };
            var ReleaseManager = new Category
                                     {
                                         Key = "Release manager",
                                         Description = "Release manager",
                                         ParentCategory = SoftwareDevelopment,
                                         Industry = educationIndustry
                                     };
            var SoftwareDeveloper = new Category
                                        {
                                            Key = "Software developer",
                                            Description = "Software developer",
                                            ParentCategory = SoftwareDevelopment,
                                            Industry = educationIndustry
                                        };
            var WebDeveloper = new Category
                                   {
                                       Key = "Web developer",
                                       Description = "Web developer",
                                       ParentCategory = SoftwareDevelopment,
                                       Industry = educationIndustry
                                   };
            var HostDeveloper = new Category
                                    {
                                        Key = "Host developer",
                                        Description = "Host developer",
                                        ParentCategory = SoftwareDevelopment,
                                        Industry = educationIndustry
                                    };
            var SAPDeveloper = new Category
                                   {
                                       Key = "SAP developer",
                                       Description = "SAP developer",
                                       ParentCategory = SoftwareDevelopment,
                                       Industry = educationIndustry
                                   };
            var SystemDeveloper = new Category
                                      {
                                          Key = "System developer",
                                          Description = "System developer",
                                          ParentCategory = SoftwareDevelopment,
                                          Industry = educationIndustry
                                      };

            //Start->Trainer
            var ITTrainer = new Category
                                {
                                    Key = "IT trainer",
                                    Description = "IT trainer",
                                    ParentCategory = Trainer,
                                    Industry = educationIndustry
                                };

            #endregion

            new List<Category>
                {
                    AdministrationSupport,
                    ArchitectureDesign,
                    BusinessAnalysisConsulting,
                    InterdisciplinaryRoles,
                    ManagementIT,
                    Network,
                    QualityAssuranceTest,
                    SoftwareDevelopment,
                    Trainer,
                    ApplicationConsultant,
                    DatabaseAdministrator,
                    ITOperator,
                    LinuxAdministrator,
                    SAPAdministrator,
                    UnixAdministrator,
                    WindowsAdministrator,
                    ApplicationServerAdministrator,
                    HelpdeskSupport,
                    ITTechnician,
                    NetworkAdministrator,
                    StorageAdministrator,
                    Webmaster,
                    CapacityManager,
                    SystemArchitect,
                    SoftwareArchitect,
                    WebDesigner,
                    BIConsultant,
                    ChangeManager,
                    ITConsultant,
                    SystemAnalyst,
                    CRMConsultant,
                    ConsultantForTradingSystems,
                    SAPConsultant,
                    Auditor,
                    BusinessDevelopmentManager,
                    DirectorBusinessDevelopment,
                    ProgramManager,
                    ProjectManager,
                    QualityAssuranceProfessional,
                    QualityManager,
                    SubprojectManager,
                    WorkPlanner,
                    BusinessAnalyst,
                    DataProtectionOfficer,
                    ManagingDirector,
                    ProjectAssistant,
                    Purchaser,
                    QualityManagementRepresentative,
                    SharedServiceCenterSpecialist,
                    TechnicalWriter,
                    ITManager,
                    ServiceLevelManager,
                    ConfigurationManager,
                    ITSecurityManager,
                    NetworkPlanner,
                    HeadOfComputerCenter,
                    ITSystemElectronicsTechnician,
                    SystemIntegrator,
                    ITAuditor,
                    Tester,
                    TestManager,
                    DatabaseDeveloper,
                    ReleaseManager,
                    SoftwareDeveloper,
                    WebDeveloper,
                    HostDeveloper,
                    SAPDeveloper,
                    SystemDeveloper,
                    ITTrainer,
                    //Education categories
                    prePrimaryEducation,
                    secondaryEducation,
                    higherEducation,
                    otherEducation,
                    supportActivitiesEducation,
                    //Information and Communication categories
                    informationService,
                    computerProgramming,
                    telecommunications,
                    motionPicture,
                    programmingBroadcasting,
                    publishingActivities,
                    softwarePublishing,
                    otherPublishing,
                    publishingNewspapers,
                    publishingDirectories,
                    bookPublishing,
                    motionPictureProductionActivities,
                    motionPicturePostProductionActivities,
                    motionPictureProjectionActivities,
                    motionPictureDistributionActivities,
                    soundRecording,
                    radioBroadcasting,
                    tvProgramming,
                    otherTelActivities,
                    satelliteTelActivities,
                    wiredTelActivities,
                    wirelessTelActivities,
                    comProgrammingActivities,
                    comConsultancy,
                    otherIT,
                    dataProcessing,
                    webPortals,
                    newsAgencyActivities,
                    otherInformationService
                }.ForEach(c => context.Categories.AddOrUpdate(c));


            //COUNTRY
            var albania = new Country
                              {
                                  Description = "Albania",
                                  Key = "Albania",
                                  ShortName = "AL",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryAlbaniaEn,
                                                              translationCountryAlbaniaDe,
                                                              translationCountryAlbaniaHr
                                                          }
                              };
            var andorra = new Country
                              {
                                  Description = "Andorra",
                                  Key = "Andorra",
                                  ShortName = "AD",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryAndorraEn,
                                                              translationCountryAndorraDe,
                                                              translationCountryAndorraHr
                                                          }
                              };
            var armenia = new Country
                              {
                                  Description = "Armenia",
                                  Key = "Armenia",
                                  ShortName = "AM",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryArmeniaEn,
                                                              translationCountryArmeniaDe,
                                                              translationCountryArmeniaHr
                                                          }
                              };
            var austria = new Country
                              {
                                  Description = "Austria",
                                  Key = "Austria",
                                  ShortName = "AT",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryAustriaEn,
                                                              translationCountryAustriaDe,
                                                              translationCountryAustriaHr
                                                          }
                              };
            var azerbaijan = new Country
                                 {
                                     Description = "Azerbaijan",
                                     Key = "Azerbaijan",
                                     ShortName = "AZ",
                                     TitleTranslations = new List<Translation>
                                                             {
                                                                 translationCountryAzerbaijanEn,
                                                                 translationCountryAzerbaijanDe,
                                                                 translationCountryAzerbaijanHr
                                                             }
                                 };
            var belarus = new Country
                              {
                                  Description = "Belarus",
                                  Key = "Belarus",
                                  ShortName = "BY",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryBelarusEn,
                                                              translationCountryBelarusDe,
                                                              translationCountryBelarusHr
                                                          }
                              };
            var belgium = new Country
                              {
                                  Description = "Belgium",
                                  Key = "Belgium",
                                  ShortName = "BE",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryBelgiumEn,
                                                              translationCountryBelgiumDe,
                                                              translationCountryBelgiumHr
                                                          }
                              };
            var bosniaAndHerzegovina = new Country
                                           {
                                               Description = "Bosnia and Herzegovina",
                                               Key = "Bosnia and Herzegovina",
                                               ShortName = "BA",
                                               TitleTranslations = new List<Translation>
                                                                       {
                                                                           translationCountryBosniaHerzegovinaEn,
                                                                           translationCountryBosniaHerzegovinaDe,
                                                                           translationCountryBosniaHerzegovinaHr
                                                                       }
                                           };
            var bulgaria = new Country
                               {
                                   Description = "Bulgaria",
                                   Key = "Bulgaria",
                                   ShortName = "BG",
                                   TitleTranslations = new List<Translation>
                                                           {
                                                               translationCountryBulgariaEn,
                                                               translationCountryBulgariaDe,
                                                               translationCountryBulgariaHr
                                                           }
                               };
            var croatia = new Country
                              {
                                  Description = "Croatia",
                                  Key = "Croatia",
                                  ShortName = "HR",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryCroatiaEn,
                                                              translationCountryCroatiaDe,
                                                              translationCountryCroatiaHr
                                                          }
                              };
            var cyprus = new Country
                             {
                                 Description = "Cyprus",
                                 Key = "Cyprus",
                                 ShortName = "CY",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryCyprusEn,
                                                             translationCountryCyprusDe,
                                                             translationCountryCyprusHr
                                                         }
                             };
            var czechRepublic = new Country
                                    {
                                        Description = "Czech Republic",
                                        Key = "Czech Republic",
                                        ShortName = "CZ",
                                        TitleTranslations = new List<Translation>
                                                                {
                                                                    translationCountryCzechRepublicEn,
                                                                    translationCountryCzechRepublicDe,
                                                                    translationCountryCzechRepublicHr
                                                                }
                                    };
            var denmark = new Country
                              {
                                  Description = "Denmark",
                                  Key = "Denmark",
                                  ShortName = "DK",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryDenmarkEn,
                                                              translationCountryDenmarkDe,
                                                              translationCountryDenmarkHr
                                                          }
                              };
            var estonia = new Country
                              {
                                  Description = "Estonia",
                                  Key = "Estonia",
                                  ShortName = "EE",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryEstoniaEn,
                                                              translationCountryEstoniaDe,
                                                              translationCountryEstoniaHr
                                                          }
                              };
            var finland = new Country
                              {
                                  Description = "Finland",
                                  Key = "Finland",
                                  ShortName = "FI",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryFinlandEn,
                                                              translationCountryFinlandDe,
                                                              translationCountryFinlandHr
                                                          }
                              };
            var france = new Country
                             {
                                 Description = "France",
                                 Key = "France",
                                 ShortName = "FR",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryFranceEn,
                                                             translationCountryFranceDe,
                                                             translationCountryFranceHr
                                                         }
                             };
            var georgia = new Country
                              {
                                  Description = "Georgia",
                                  Key = "Georgia",
                                  ShortName = "GE",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryGeorgiaEn,
                                                              translationCountryGeorgiaDe,
                                                              translationCountryGeorgiaHr
                                                          }
                              };
            var germany = new Country
                              {
                                  Description = "Germany",
                                  Key = "Germany",
                                  ShortName = "DE",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryGermanyEn,
                                                              translationCountryGermanyDe,
                                                              translationCountryGermanyHr
                                                          }
                              };
            var greece = new Country
                             {
                                 Description = "Greece",
                                 Key = "Greece",
                                 ShortName = "GR",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryGreeceEn,
                                                             translationCountryGreeceDe,
                                                             translationCountryGreeceHr
                                                         }
                             };
            var hungary = new Country
                              {
                                  Description = "Hungary",
                                  Key = "Hungary",
                                  ShortName = "HU",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryHungaryEn,
                                                              translationCountryHungaryDe,
                                                              translationCountryHungaryHr
                                                          }
                              };
            var iceland = new Country
                              {
                                  Description = "Iceland",
                                  Key = "Iceland",
                                  ShortName = "IS",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryIcelandEn,
                                                              translationCountryIcelandDe,
                                                              translationCountryIcelandHr
                                                          }
                              };
            var ireland = new Country
                              {
                                  Description = "Ireland",
                                  Key = "Ireland",
                                  ShortName = "IE",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryIrelandEn,
                                                              translationCountryIrelandDe,
                                                              translationCountryIrelandHr
                                                          }
                              };
            var italy = new Country
                            {
                                Description = "Italy",
                                Key = "Italy",
                                ShortName = "IT",
                                TitleTranslations = new List<Translation>
                                                        {
                                                            translationCountryItalyEn,
                                                            translationCountryItalyDe,
                                                            translationCountryItalyHr
                                                        }
                            };
            var kosovo = new Country
                             {
                                 Description = "Kosovo",
                                 Key = "Kosovo",
                                 ShortName = "KV",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryKosovoEn,
                                                             translationCountryKosovoDe,
                                                             translationCountryKosovoHr
                                                         }
                             };
            var latvia = new Country
                             {
                                 Description = "Latvia",
                                 Key = "Latvia",
                                 ShortName = "LV",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryLatviaEn,
                                                             translationCountryLatviaDe,
                                                             translationCountryLatviaHr
                                                         }
                             };
            var liechtenstein = new Country
                                    {
                                        Description = "Liechtenstein",
                                        Key = "Liechtenstein",
                                        ShortName = "LI",
                                        TitleTranslations = new List<Translation>
                                                                {
                                                                    translationCountryLiechtensteinEn,
                                                                    translationCountryLiechtensteinDe,
                                                                    translationCountryLiechtensteinHr
                                                                }
                                    };
            var lithuania = new Country
                                {
                                    Description = "Lithuania",
                                    Key = "Lithuania",
                                    ShortName = "LT",
                                    TitleTranslations = new List<Translation>
                                                            {
                                                                translationCountryLithuaniaEn,
                                                                translationCountryLithuaniaDe,
                                                                translationCountryLithuaniaHr
                                                            }
                                };
            var luxembourg = new Country
                                 {
                                     Description = "Luxembourg",
                                     Key = "Luxembourg",
                                     ShortName = "LU",
                                     TitleTranslations = new List<Translation>
                                                             {
                                                                 translationCountryLuxembourgEn,
                                                                 translationCountryLuxembourgDe,
                                                                 translationCountryLuxembourgHr
                                                             }
                                 };
            var macedonia = new Country
                                {
                                    Description = "Macedonia",
                                    Key = "Macedonia",
                                    ShortName = "MK",
                                    TitleTranslations = new List<Translation>
                                                            {
                                                                translationCountryMacedoniaEn,
                                                                translationCountryMacedoniaDe,
                                                                translationCountryMacedoniaHr
                                                            }
                                };
            var malta = new Country
                            {
                                Description = "Malta",
                                Key = "Malta",
                                ShortName = "MT",
                                TitleTranslations = new List<Translation>
                                                        {
                                                            translationCountryMaltaEn,
                                                            translationCountryMaltaDe,
                                                            translationCountryMaltaHr
                                                        }
                            };
            var moldova = new Country
                              {
                                  Description = "Moldova",
                                  Key = "Moldova",
                                  ShortName = "MD",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryMoldovaEn,
                                                              translationCountryMoldovaDe,
                                                              translationCountryMoldovaHr
                                                          }
                              };
            var monaco = new Country
                             {
                                 Description = "Monaco",
                                 Key = "Monaco",
                                 ShortName = "MC",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryMonacoEn,
                                                             translationCountryMonacoDe,
                                                             translationCountryMonacoHr
                                                         }
                             };
            var montenegro = new Country
                                 {
                                     Description = "Montenegro",
                                     Key = "Montenegro",
                                     ShortName = "ME",
                                     TitleTranslations = new List<Translation>
                                                             {
                                                                 translationCountryMontenegroEn,
                                                                 translationCountryMontenegroDe,
                                                                 translationCountryMontenegroHr
                                                             }
                                 };
            var theNetherlands = new Country
                                     {
                                         Description = "Netherlands",
                                         Key = "Netherlands",
                                         ShortName = "NL",
                                         TitleTranslations = new List<Translation>
                                                                 {
                                                                     translationCountryNetherlandsEn,
                                                                     translationCountryNetherlandsDe,
                                                                     translationCountryNetherlandsHr
                                                                 }
                                     };
            var norway = new Country
                             {
                                 Description = "Norway",
                                 Key = "Norway",
                                 ShortName = "NO",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryNorwayEn,
                                                             translationCountryNorwayDe,
                                                             translationCountryNorwayHr
                                                         }
                             };
            var poland = new Country
                             {
                                 Description = "Poland",
                                 Key = "Poland",
                                 ShortName = "PL",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryPolandEn,
                                                             translationCountryPolandDe,
                                                             translationCountryPolandHr
                                                         }
                             };
            var portugal = new Country
                               {
                                   Description = "Portugal",
                                   Key = "Portugal",
                                   ShortName = "PT",
                                   TitleTranslations = new List<Translation>
                                                           {
                                                               translationCountryPortugalEn,
                                                               translationCountryPortugalDe,
                                                               translationCountryPortugalHr
                                                           }
                               };
            var romania = new Country
                              {
                                  Description = "Romania",
                                  Key = "Romania",
                                  ShortName = "RO",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryRomaniaEn,
                                                              translationCountryRomaniaDe,
                                                              translationCountryRomaniaHr
                                                          }
                              };
            var russia = new Country
                             {
                                 Description = "Russia",
                                 Key = "Russia",
                                 ShortName = "RU",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryRussiaEn,
                                                             translationCountryRussiaDe,
                                                             translationCountryRussiaHr
                                                         }
                             };
            var sanMarino = new Country
                                {
                                    Description = "San Marino",
                                    Key = "San Marino",
                                    ShortName = "SM",
                                    TitleTranslations = new List<Translation>
                                                            {
                                                                translationCountrySanMarinoEn,
                                                                translationCountrySanMarinoDe,
                                                                translationCountrySanMarinoHr
                                                            }
                                };
            var serbia = new Country
                             {
                                 Description = "Serbia",
                                 Key = "Serbia",
                                 ShortName = "RS",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountrySerbiaEn,
                                                             translationCountrySerbiaDe,
                                                             translationCountrySerbiaHr
                                                         }
                             };
            var slovakia = new Country
                               {
                                   Description = "Slovakia",
                                   Key = "Slovakia",
                                   ShortName = "SK",
                                   TitleTranslations = new List<Translation>
                                                           {
                                                               translationCountrySlovakiaEn,
                                                               translationCountrySlovakiaDe,
                                                               translationCountrySlovakiaHr
                                                           }
                               };
            var slovenia = new Country
                               {
                                   Description = "Slovenia",
                                   Key = "Slovenia",
                                   ShortName = "SI",
                                   TitleTranslations = new List<Translation>
                                                           {
                                                               translationCountrySloveniaEn,
                                                               translationCountrySloveniaDe,
                                                               translationCountrySloveniaHr
                                                           }
                               };
            var spain = new Country
                            {
                                Description = "Spain",
                                Key = "Spain",
                                ShortName = "ES",
                                TitleTranslations = new List<Translation>
                                                        {
                                                            translationCountrySpainEn,
                                                            translationCountrySpainDe,
                                                            translationCountrySpainHr
                                                        }
                            };
            var sweden = new Country
                             {
                                 Description = "Sweden",
                                 Key = "Sweden",
                                 ShortName = "SE",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountrySwedenEn,
                                                             translationCountrySwedenDe,
                                                             translationCountrySwedenHr
                                                         }
                             };
            var switzerland = new Country
                                  {
                                      Description = "Switzerland",
                                      Key = "Switzerland",
                                      ShortName = "CH",
                                      TitleTranslations = new List<Translation>
                                                              {
                                                                  translationCountrySwitzerlandEn,
                                                                  translationCountrySwitzerlandDe,
                                                                  translationCountrySwitzerlandHr
                                                              }
                                  };
            var turkey = new Country
                             {
                                 Description = "Turkey",
                                 Key = "Turkey",
                                 ShortName = "TR",
                                 TitleTranslations = new List<Translation>
                                                         {
                                                             translationCountryTurkeyEn,
                                                             translationCountryTurkeyDe,
                                                             translationCountryTurkeyHr
                                                         }
                             };
            var ukraine = new Country
                              {
                                  Description = "Ukraine",
                                  Key = "Ukraine",
                                  ShortName = "UA",
                                  TitleTranslations = new List<Translation>
                                                          {
                                                              translationCountryUkraineEn,
                                                              translationCountryUkraineDe,
                                                              translationCountryUkraineHr
                                                          }
                              };
            var unitedKingdom = new Country
                                    {
                                        Description = "United Kingdom",
                                        Key = "United Kingdom",
                                        ShortName = "GB",
                                        TitleTranslations = new List<Translation>
                                                                {
                                                                    translationCountryUnitedKingdomEn,
                                                                    translationCountryUnitedKingdomDe,
                                                                    translationCountryUnitedKingdomHr
                                                                }
                                    };
            var vaticanCity = new Country
                                  {
                                      Description = "Vatican City",
                                      Key = "Vatican City",
                                      ShortName = "VA",
                                      TitleTranslations = new List<Translation>
                                                              {
                                                                  translationCountryVaticanCityEn,
                                                                  translationCountryVaticanCityDe,
                                                                  translationCountryVaticanCityHr
                                                              }
                                  };

            new List<Country>
                {
                    albania,
                    andorra,
                    armenia,
                    austria,
                    azerbaijan,
                    belarus,
                    belgium,
                    bosniaAndHerzegovina,
                    bulgaria,
                    croatia,
                    cyprus,
                    czechRepublic,
                    denmark,
                    estonia,
                    finland,
                    france,
                    georgia,
                    germany,
                    greece,
                    hungary,
                    iceland,
                    ireland,
                    italy,
                    kosovo,
                    latvia,
                    liechtenstein,
                    lithuania,
                    luxembourg,
                    macedonia,
                    malta,
                    moldova,
                    monaco,
                    montenegro,
                    theNetherlands,
                    norway,
                    poland,
                    portugal,
                    romania,
                    russia,
                    sanMarino,
                    serbia,
                    slovakia,
                    slovenia,
                    spain,
                    sweden,
                    switzerland,
                    turkey,
                    ukraine,
                    unitedKingdom,
                    vaticanCity
                }.ForEach(c => context.Countries.AddOrUpdate(c));


            //EDUCATION
            var bachelor = new Education
                               {
                                   Title = "B.A.",
                                   Key = "Bachelor",
                                   Description = "Bachelor"
                               };
            var master = new Education
                             {
                                 Title = "MSc",
                                 Key = "Master",
                                 Description = "Master of Science"
                             };
            var di = new Education
                         {
                             Title = "D.I.",
                             Key = "Engineer",
                             Description = "Graduate Engineer"
                         };
            var phd = new Education
                          {
                              Title = "Ph.D",
                              Key = "Doctor",
                              Description = "Doctor"
                          };

            new List<Education>
                {
                    bachelor,
                    master,
                    di,
                    phd
                }.ForEach(e => context.Educations.AddOrUpdate(e));


            //Expert PROFILE
            var ExpertProfile1 = new ExpertProfile
                                     {
                                         IsDefault = true,
                                         Title = "Viktoria Helm",
                                         Description = "IT Consultant",
                                         Website = "www.sandragorgieva.com",
                                         Skype = "gorgieva_sandra",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 10,
                                         DailyRate = 100,
                                         MonthlyRate = 1000,
                                         AnnualRate = 10000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 2,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "I have worked for Google and Microsoft",
                                         Location = "Vienna",
                                         XLocation = 48.2088,
                                         YLocation = 16.3726,
                                         AvailabilityStatus = 1,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "Computer Science",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = bachelor
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Arificial Intelligence",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = phd
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {new CategorySkill {Category = ITManager, Experience = 3, Level = 2}},
                                         Country = austria,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user1,
                                         Industry = informationAndCommunicationIndustry
                                     };

            var ExpertProfile2 = new ExpertProfile
                                     {
                                         IsDefault = true,
                                         Title = "Roland Mombaur",
                                         Description = "Quality and Process Expert, Writer",
                                         Website = "www.somewebsite.com",
                                         Skype = "Skype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 10,
                                         DailyRate = 100,
                                         MonthlyRate = 1000,
                                         AnnualRate = 10000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 1,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "I have experience in electronics",
                                         Location = "Bratislava",
                                         XLocation = 48.1485,
                                         YLocation = 17.1067,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 2,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "Software Engineering",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = master
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Software Architectures",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = phd
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = DatabaseDeveloper, Experience = 3, Level = 2}
                                                 },
                                         Country = slovakia,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user2,
                                         Industry = informationAndCommunicationIndustry
                                     };
            var ExpertProfile3 = new ExpertProfile
                                     {
                                         IsDefault = true,
                                         Title = "Steffen Bangsow",
                                         Description =
                                             "IT Projectmanagement, SAP FI & ERP Customizing, Banking Expert",
                                         Website = "www.web1.com",
                                         Skype = "spaseskype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 20,
                                         DailyRate = 200,
                                         MonthlyRate = 2000,
                                         AnnualRate = 20000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 3,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "Microsoft certified",
                                         Location = "Budapest",
                                         XLocation = 47.5000,
                                         YLocation = 19.0500,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 3,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "Networking Technologies",
                                                             University = "Technical University, Vienna, Austria",
                                                             Education = master
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = LinuxAdministrator, Experience = 3, Level = 2}
                                                 },
                                         Country = hungary,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user3,
                                         Industry = educationIndustry
                                     };

            var ExpertProfile4 = new ExpertProfile
                                     {
                                         IsDefault = true,
                                         Title = "Klaus Rheinwald",
                                         Description =
                                             "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                         Website = "www.web2.com",
                                         Skype = "gorgiskype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 20,
                                         DailyRate = 200,
                                         MonthlyRate = 2000,
                                         AnnualRate = 20000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 5,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "This is other",
                                         Location = "Munich",
                                         XLocation = 48.1333,
                                         YLocation = 11.5667,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 2,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "IT Systems",
                                                             University = "Univeristy of Technology, Vienna, Austria",
                                                             Education = bachelor
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Software Architectures",
                                                             University = "Univeristy of Technology, Munich, Germany",
                                                             Education = master
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                 },
                                         Country = germany,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user4,
                                         Industry = educationIndustry
                                     };
            var ExpertProfile5 = new ExpertProfile
                                     {
                                         IsDefault = false,
                                         Title = "Anna Tomson",
                                         Description =
                                             "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                         Website = "www.web2.com",
                                         Skype = "gorgiskype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 30,
                                         DailyRate = 300,
                                         MonthlyRate = 3000,
                                         AnnualRate = 30000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 1,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "This is other",
                                         Location = "Zurich",
                                         XLocation = 47.3690,
                                         YLocation = 8.5380,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 2,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "IT Systems",
                                                             University = "Univeristy of Technology, Vienna, Austria",
                                                             Education = bachelor
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Software Architectures",
                                                             University = "Univeristy of Technology, Munich, Germany",
                                                             Education = master
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                 },
                                         Country = switzerland,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user4,
                                         Industry = creativeIndustry
                                     };
            var ExpertProfile6 = new ExpertProfile
                                     {
                                         IsDefault = false,
                                         Title = "Michael Tomson",
                                         Description = "IT Consultant",
                                         Website = "www.sandragorgieva.com",
                                         Skype = "gorgieva_sandra",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 10,
                                         DailyRate = 100,
                                         MonthlyRate = 1000,
                                         AnnualRate = 10000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 1,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "I have worked for Google and Microsoft",
                                         Location = "Vienna",
                                         XLocation = 48.2088,
                                         YLocation = 16.3726,
                                         AvailabilityStatus = 1,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "Computer Science",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = bachelor
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Arificial Intelligence",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = phd
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {new CategorySkill {Category = ITManager, Experience = 3, Level = 2}},
                                         Country = austria,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user1,
                                         Industry = informationAndCommunicationIndustry
                                     };

            var ExpertProfile7 = new ExpertProfile
                                     {
                                         IsDefault = false,
                                         Title = "Anonymos profile",
                                         Description = "Quality and Process Expert, Writer",
                                         Website = "www.somewebsite.com",
                                         Skype = "Skype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 10,
                                         DailyRate = 100,
                                         MonthlyRate = 1000,
                                         AnnualRate = 10000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 4,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "I have experience in electronics",
                                         Location = "Bratislava",
                                         XLocation = 48.1485,
                                         YLocation = 17.1067,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 3,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "Software Engineering",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = master
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Software Architectures",
                                                             University = "University of Vienna, Vienna, Austria",
                                                             Education = phd
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = DatabaseDeveloper, Experience = 3, Level = 2}
                                                 },
                                         Country = slovakia,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user2,
                                         Industry = informationAndCommunicationIndustry
                                     };
            var ExpertProfile8 = new ExpertProfile
                                     {
                                         IsDefault = false,
                                         Title = "John Smith",
                                         Description =
                                             "IT Projectmanagement, SAP FI & ERP Customizing, Banking Expert",
                                         Website = "www.web1.com",
                                         Skype = "spaseskype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 20,
                                         DailyRate = 200,
                                         MonthlyRate = 2000,
                                         AnnualRate = 20000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 5,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "Microsoft certified",
                                         Location = "Budapest",
                                         XLocation = 47.5000,
                                         YLocation = 19.0500,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 2,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "Networking Technologies",
                                                             University = "Technical University, Vienna, Austria",
                                                             Education = master
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = LinuxAdministrator, Experience = 3, Level = 2}
                                                 },
                                         Country = hungary,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user3,
                                         Industry = educationIndustry
                                     };

            var ExpertProfile9 = new ExpertProfile
                                     {
                                         IsDefault = false,
                                         Title = "Anna Richards",
                                         Description =
                                             "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                         Website = "www.web2.com",
                                         Skype = "gorgiskype",
                                         Facebook = "Facebook",
                                         Twitter = "Twitter",
                                         Linkedin = "Linkedin",
                                         HourRate = 20,
                                         DailyRate = 200,
                                         MonthlyRate = 2000,
                                         AnnualRate = 20000,
                                         CommentRate = "This is comment for rates",
                                         JobType = 1,
                                         Experience =
                                             "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                         References = "This is references",
                                         Availability = "This is availability",
                                         Other = "This is other",
                                         Location = "Munich",
                                         XLocation = 48.1333,
                                         YLocation = 11.5667,
                                         Email = "gorgieva_sandra@yahoo.com",
                                         PhoneNumber = "0038970111222",
                                         AvailabilityStatus = 2,
                                         EducationSkills =
                                             new List<EducationSkill>
                                                 {
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 1997,
                                                             EndYear = 2003,
                                                             Program = "IT Systems",
                                                             University = "Univeristy of Technology, Vienna, Austria",
                                                             Education = bachelor
                                                         },
                                                     new EducationSkill
                                                         {
                                                             BeginYear = 2003,
                                                             EndYear = 2007,
                                                             Program = "Software Architectures",
                                                             University = "Univeristy of Technology, Munich, Germany",
                                                             Education = master
                                                         }
                                                 },
                                         CategorySkills =
                                             new List<CategorySkill>
                                                 {
                                                     new CategorySkill
                                                         {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                 },
                                         Country = germany,
                                         Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                         Cv = "Cv_default",
                                         User = user4,
                                         Industry = educationIndustry
                                     };
            var ExpertProfile10 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Anonymos profile",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 30,
                                          DailyRate = 300,
                                          MonthlyRate = 3000,
                                          AnnualRate = 30000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 3,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Zurich",
                                          XLocation = 47.3690,
                                          YLocation = 8.5380,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = switzerland,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user4,
                                          Industry = creativeIndustry
                                      };
            var ExpertProfile11 = new ExpertProfile
                                      {
                                          IsDefault = true,
                                          Title = "Leo Tomson",
                                          Description = "IT Consultant",
                                          Website = "www.sandragorgieva.com",
                                          Skype = "gorgieva_sandra",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 10,
                                          DailyRate = 100,
                                          MonthlyRate = 1000,
                                          AnnualRate = 10000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 4,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "I have worked for Google and Microsoft",
                                          Location = "Vienna",
                                          XLocation = 48.2088,
                                          YLocation = 16.3726,
                                          AvailabilityStatus = 1,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Computer Science",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Arificial Intelligence",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = phd
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = ITManager, Experience = 3, Level = 2}
                                                  },
                                          Country = austria,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user5,
                                          Industry = informationAndCommunicationIndustry
                                      };

            var ExpertProfile12 = new ExpertProfile
                                      {
                                          IsDefault = true,
                                          Title = "Elena Nikolova",
                                          Description = "Quality and Process Expert, Writer",
                                          Website = "www.somewebsite.com",
                                          Skype = "Skype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 10,
                                          DailyRate = 100,
                                          MonthlyRate = 1000,
                                          AnnualRate = 10000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 5,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "I have experience in electronics",
                                          Location = "Bratislava",
                                          XLocation = 48.1485,
                                          YLocation = 17.1067,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 3,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Software Engineering",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = master
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = phd
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = DatabaseDeveloper, Experience = 3, Level = 2}
                                                  },
                                          Country = slovakia,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user6,
                                          Industry = informationAndCommunicationIndustry
                                      };
            var ExpertProfile13 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Klaus Richards",
                                          Description =
                                              "IT Projectmanagement, SAP FI & ERP Customizing, Banking Expert",
                                          Website = "www.web1.com",
                                          Skype = "spaseskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 20,
                                          DailyRate = 200,
                                          MonthlyRate = 2000,
                                          AnnualRate = 20000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "Microsoft certified",
                                          Location = "Budapest",
                                          XLocation = 47.5000,
                                          YLocation = 19.0500,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 3,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Networking Technologies",
                                                              University = "Technical University, Vienna, Austria",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = LinuxAdministrator, Experience = 3, Level = 2}
                                                  },
                                          Country = hungary,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user5,
                                          Industry = educationIndustry
                                      };

            var ExpertProfile14 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Tom Smith",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 20,
                                          DailyRate = 200,
                                          MonthlyRate = 2000,
                                          AnnualRate = 20000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Munich",
                                          XLocation = 48.1333,
                                          YLocation = 11.5667,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = germany,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user6,
                                          Industry = educationIndustry
                                      };
            var ExpertProfile15 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Anonymos profile",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 30,
                                          DailyRate = 300,
                                          MonthlyRate = 3000,
                                          AnnualRate = 30000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Zurich",
                                          XLocation = 47.3690,
                                          YLocation = 8.5380,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = switzerland,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user5,
                                          Industry = creativeIndustry
                                      };
            var ExpertProfile16 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Richard John Brighton",
                                          Description = "IT Consultant",
                                          Website = "www.sandragorgieva.com",
                                          Skype = "gorgieva_sandra",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 10,
                                          DailyRate = 100,
                                          MonthlyRate = 1000,
                                          AnnualRate = 10000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 4,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "I have worked for Google and Microsoft",
                                          Location = "Vienna",
                                          XLocation = 48.2088,
                                          YLocation = 16.3726,
                                          AvailabilityStatus = 2,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Computer Science",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Arificial Intelligence",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = phd
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = ITManager, Experience = 3, Level = 2}
                                                  },
                                          Country = austria,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user6,
                                          Industry = informationAndCommunicationIndustry
                                      };

            var ExpertProfile17 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Anonymos profile",
                                          Description = "Quality and Process Expert, Writer",
                                          Website = "www.somewebsite.com",
                                          Skype = "Skype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 10,
                                          DailyRate = 100,
                                          MonthlyRate = 1000,
                                          AnnualRate = 10000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "I have experience in electronics",
                                          Location = "Bratislava",
                                          XLocation = 48.1485,
                                          YLocation = 17.1067,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 1,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Software Engineering",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = master
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = phd
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = DatabaseDeveloper, Experience = 3, Level = 2}
                                                  },
                                          Country = slovakia,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user2,
                                          Industry = informationAndCommunicationIndustry
                                      };
            var ExpertProfile18 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Anonymos profile",
                                          Description =
                                              "IT Projectmanagement, SAP FI & ERP Customizing, Banking Expert",
                                          Website = "www.web1.com",
                                          Skype = "spaseskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 20,
                                          DailyRate = 200,
                                          MonthlyRate = 2000,
                                          AnnualRate = 20000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "Microsoft certified",
                                          Location = "Budapest",
                                          XLocation = 47.5000,
                                          YLocation = 19.0500,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Networking Technologies",
                                                              University = "Technical University, Vienna, Austria",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = LinuxAdministrator, Experience = 3, Level = 2}
                                                  },
                                          Country = hungary,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user3,
                                          Industry = educationIndustry
                                      };

            var ExpertProfile19 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Julia Charls",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 20,
                                          DailyRate = 200,
                                          MonthlyRate = 2000,
                                          AnnualRate = 20000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Munich",
                                          XLocation = 48.1333,
                                          YLocation = 11.5667,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = germany,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user4,
                                          Industry = educationIndustry
                                      };
            var ExpertProfile20 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Rikardo Tomson",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 30,
                                          DailyRate = 300,
                                          MonthlyRate = 3000,
                                          AnnualRate = 30000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Zurich",
                                          XLocation = 47.3690,
                                          YLocation = 8.5380,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = switzerland,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user4,
                                          Industry = creativeIndustry
                                      };
            var ExpertProfile21 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Anonymos profile",
                                          Description = "IT Consultant",
                                          Website = "www.sandragorgieva.com",
                                          Skype = "gorgieva_sandra",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 10,
                                          DailyRate = 100,
                                          MonthlyRate = 1000,
                                          AnnualRate = 10000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "I have worked for Google and Microsoft",
                                          Location = "Vienna",
                                          XLocation = 48.2088,
                                          YLocation = 16.3726,
                                          AvailabilityStatus = 1,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Computer Science",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Arificial Intelligence",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = phd
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = ITManager, Experience = 3, Level = 2}
                                                  },
                                          Country = austria,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user1,
                                          Industry = informationAndCommunicationIndustry
                                      };

            var ExpertProfile22 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Ryan Helms",
                                          Description = "Quality and Process Expert, Writer",
                                          Website = "www.somewebsite.com",
                                          Skype = "Skype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 10,
                                          DailyRate = 100,
                                          MonthlyRate = 1000,
                                          AnnualRate = 10000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 4,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "I have experience in electronics",
                                          Location = "Bratislava",
                                          XLocation = 48.1485,
                                          YLocation = 17.1067,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 3,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Software Engineering",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = master
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "University of Vienna, Vienna, Austria",
                                                              Education = phd
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = DatabaseDeveloper, Experience = 3, Level = 2}
                                                  },
                                          Country = slovakia,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user2,
                                          Industry = informationAndCommunicationIndustry
                                      };
            var ExpertProfile23 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Bryan Brighton",
                                          Description =
                                              "IT Projectmanagement, SAP FI & ERP Customizing, Banking Expert",
                                          Website = "www.web1.com",
                                          Skype = "spaseskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 20,
                                          DailyRate = 200,
                                          MonthlyRate = 2000,
                                          AnnualRate = 20000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 5,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "Microsoft certified",
                                          Location = "Budapest",
                                          XLocation = 47.5000,
                                          YLocation = 19.0500,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 3,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "Networking Technologies",
                                                              University = "Technical University, Vienna, Austria",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = LinuxAdministrator, Experience = 3, Level = 2}
                                                  },
                                          Country = hungary,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user3,
                                          Industry = educationIndustry
                                      };

            var ExpertProfile24 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Jelena Planojevic",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 20,
                                          DailyRate = 200,
                                          MonthlyRate = 2000,
                                          AnnualRate = 20000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 1,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Munich",
                                          XLocation = 48.1333,
                                          YLocation = 11.5667,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = germany,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user4,
                                          Industry = educationIndustry
                                      };
            var ExpertProfile25 = new ExpertProfile
                                      {
                                          IsDefault = false,
                                          Title = "Rebecca Shaffild",
                                          Description =
                                              "IT-Consultant / System Integrator; System-Administration, Netzwerk Security",
                                          Website = "www.web2.com",
                                          Skype = "gorgiskype",
                                          Facebook = "Facebook",
                                          Twitter = "Twitter",
                                          Linkedin = "Linkedin",
                                          HourRate = 30,
                                          DailyRate = 300,
                                          MonthlyRate = 3000,
                                          AnnualRate = 30000,
                                          CommentRate = "This is comment for rates",
                                          JobType = 7,
                                          Experience =
                                              "I have a strong technical and solution orientated way of thinking and my flexible and innovative mind allowes me to solve even complex mechatronical problems.Should you need new inspiration with a Position and technical proposals for solutions I am happy to take the challenge.",
                                          References = "This is references",
                                          Availability = "This is availability",
                                          Other = "This is other",
                                          Location = "Zurich",
                                          XLocation = 47.3690,
                                          YLocation = 8.5380,
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "0038970111222",
                                          AvailabilityStatus = 2,
                                          EducationSkills =
                                              new List<EducationSkill>
                                                  {
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 1997,
                                                              EndYear = 2003,
                                                              Program = "IT Systems",
                                                              University = "Univeristy of Technology, Vienna, Austria",
                                                              Education = bachelor
                                                          },
                                                      new EducationSkill
                                                          {
                                                              BeginYear = 2003,
                                                              EndYear = 2007,
                                                              Program = "Software Architectures",
                                                              University = "Univeristy of Technology, Munich, Germany",
                                                              Education = master
                                                          }
                                                  },
                                          CategorySkills =
                                              new List<CategorySkill>
                                                  {
                                                      new CategorySkill
                                                          {Category = UnixAdministrator, Experience = 2, Level = 2}
                                                  },
                                          Country = switzerland,
                                          Photo = "../../Content/img/250X250_Office-Male-icon.png",
                                          Cv = "Cv_default",
                                          User = user4,
                                          Industry = creativeIndustry
                                      };

            new List<ExpertProfile>
                {
                    ExpertProfile1,
                    ExpertProfile2,
                    ExpertProfile3,
                    ExpertProfile4,
                    ExpertProfile5,
                    ExpertProfile6,
                    ExpertProfile7,
                    ExpertProfile8,
                    ExpertProfile9,
                    ExpertProfile10,
                    ExpertProfile11,
                    ExpertProfile12,
                    ExpertProfile13,
                    ExpertProfile14,
                    ExpertProfile15,
                    ExpertProfile16,
                    ExpertProfile17,
                    ExpertProfile18,
                    ExpertProfile19,
                    ExpertProfile20,
                    ExpertProfile21,
                    ExpertProfile22,
                    ExpertProfile23,
                    ExpertProfile24,
                    ExpertProfile25
                }.ForEach(p => context.ExpertProfiles.AddOrUpdate(p));

            //LANGUAGE SKILL
            var slovenianOne = new LanguageSkill {Level = 1, Language = slovenian, ExpertProfile = ExpertProfile1};
            //var arabicTwo = new LanguageSkill {Level = 2, Language = arabic, ExpertProfile = ExpertProfile1};
            //var arabicThree = new LanguageSkill {Level = 3, Language = arabic, ExpertProfile = ExpertProfile1};
            //var bulgarianOne = new LanguageSkill {Level = 1, Language = bulgarian, ExpertProfile = ExpertProfile1};
            //var bulgarianTwo = new LanguageSkill {Level = 2, Language = bulgarian, ExpertProfile = ExpertProfile1};
            var bulgarianThree = new LanguageSkill {Level = 3, Language = bulgarian, ExpertProfile = ExpertProfile1};
            //var chineseOne = new LanguageSkill {Level = 1, Language = chinese, ExpertProfile = ExpertProfile1};
            var albanianTwo = new LanguageSkill {Level = 2, Language = albanian, ExpertProfile = ExpertProfile2};
            //var chineseThree = new LanguageSkill {Level = 3, Language = chinese, ExpertProfile = ExpertProfile1};
            //var danishOne = new LanguageSkill {Level = 1, Language = danish, ExpertProfile = ExpertProfile1};
            //var danishTwo = new LanguageSkill {Level = 2, Language = danish, ExpertProfile = ExpertProfile1};
            //var danishThree = new LanguageSkill {Level = 3, Language = danish, ExpertProfile = ExpertProfile1};
            var englishOne = new LanguageSkill {Level = 1, Language = english, ExpertProfile = ExpertProfile1};
            var englishTwo = new LanguageSkill {Level = 2, Language = english, ExpertProfile = ExpertProfile2};
            var englishThree = new LanguageSkill {Level = 3, Language = english, ExpertProfile = ExpertProfile3};
            //var finnishOne = new LanguageSkill {Level = 1, Language = finnish, ExpertProfile = ExpertProfile1};
            var finnishTwo = new LanguageSkill {Level = 2, Language = finnish, ExpertProfile = ExpertProfile4};
            //var finnishThree = new LanguageSkill {Level = 3, Language = finnish, ExpertProfile = ExpertProfile1};
            var frenchOne = new LanguageSkill {Level = 1, Language = french, ExpertProfile = ExpertProfile5};
            var frenchTwo = new LanguageSkill {Level = 2, Language = french, ExpertProfile = ExpertProfile6};
            //var frenchThree = new LanguageSkill {Level = 3, Language = french, ExpertProfile = ExpertProfile1};
            var italianOne = new LanguageSkill {Level = 1, Language = italian, ExpertProfile = ExpertProfile7};
            var italianTwo = new LanguageSkill {Level = 2, Language = french, ExpertProfile = ExpertProfile8};
            var italianThree = new LanguageSkill {Level = 3, Language = french, ExpertProfile = ExpertProfile9};
            var germanOne = new LanguageSkill {Level = 1, Language = german, ExpertProfile = ExpertProfile1};
            var germanTwo = new LanguageSkill {Level = 2, Language = german, ExpertProfile = ExpertProfile10};
            var germanThree = new LanguageSkill {Level = 3, Language = german, ExpertProfile = ExpertProfile11};
            //var greekOne = new LanguageSkill {Level = 1, Language = greek, ExpertProfile = ExpertProfile1};
            var greekTwo = new LanguageSkill {Level = 2, Language = greek, ExpertProfile = ExpertProfile12};
            var greekThree = new LanguageSkill {Level = 3, Language = greek, ExpertProfile = ExpertProfile10};
            //var hungarianOne = new LanguageSkill {Level = 1, Language = hungarian, ExpertProfile = ExpertProfile1};
            //var hungarianTwo = new LanguageSkill {Level = 2, Language = hungarian, ExpertProfile = ExpertProfile1};
            var hungarianThree = new LanguageSkill
                                     {Level = 3, Language = hungarian, ExpertProfile = ExpertProfile16};
            //var hindiOne = new LanguageSkill {Level = 1, Language = hindi, ExpertProfile = ExpertProfile1};
            //var hindiTwo = new LanguageSkill {Level = 2, Language = hindi, ExpertProfile = ExpertProfile1};
            //var hindiThree = new LanguageSkill {Level = 3, Language = hindi, ExpertProfile = ExpertProfile1};
            //var japaneseOne = new LanguageSkill {Level = 1, Language = japanese, ExpertProfile = ExpertProfile1};
            var serbianTwo = new LanguageSkill {Level = 2, Language = serbian, ExpertProfile = ExpertProfile17};
            var serbianThree = new LanguageSkill {Level = 3, Language = serbian, ExpertProfile = ExpertProfile17};
            //var dutchOne = new LanguageSkill {Level = 1, Language = dutch, ExpertProfile = ExpertProfile1};
            var dutchTwo = new LanguageSkill {Level = 2, Language = dutch, ExpertProfile = ExpertProfile20};
            //var dutchThree = new LanguageSkill {Level = 3, Language = dutch, ExpertProfile = ExpertProfile1};
            var norwegianOne = new LanguageSkill {Level = 1, Language = norwegian, ExpertProfile = ExpertProfile21};
            //var norwegianTwo = new LanguageSkill {Level = 2, Language = norwegian, ExpertProfile = ExpertProfile1};
            //var norwegianThree = new LanguageSkill {Level = 3, Language = norwegian, ExpertProfile = ExpertProfile1};
            //var persianOne = new LanguageSkill {Level = 1, Language = persian, ExpertProfile = ExpertProfile1};
            //var persianTwo = new LanguageSkill {Level = 2, Language = persian, ExpertProfile = ExpertProfile1};
            //var persianThree = new LanguageSkill {Level = 3, Language = persian, ExpertProfile = ExpertProfile1};
            //var polishOne = new LanguageSkill {Level = 1, Language = polish, ExpertProfile = ExpertProfile1};
            var polishTwo = new LanguageSkill {Level = 2, Language = polish, ExpertProfile = ExpertProfile22};
            var polishThree = new LanguageSkill {Level = 3, Language = polish, ExpertProfile = ExpertProfile16};
            //var portugueseOne = new LanguageSkill {Level = 1, Language = portuguese, ExpertProfile = ExpertProfile1};
            var portugueseTwo = new LanguageSkill
                                    {Level = 2, Language = portuguese, ExpertProfile = ExpertProfile23};
            var portugueseThree = new LanguageSkill
                                      {Level = 3, Language = portuguese, ExpertProfile = ExpertProfile24};
            //var romanianOne = new LanguageSkill {Level = 1, Language = romanian, ExpertProfile = ExpertProfile4};
            var romanianTwo = new LanguageSkill {Level = 2, Language = romanian, ExpertProfile = ExpertProfile25};
            var romanianThree = new LanguageSkill {Level = 3, Language = romanian, ExpertProfile = ExpertProfile18};
            var russianOne = new LanguageSkill {Level = 1, Language = russian, ExpertProfile = ExpertProfile19};
            var russianTwo = new LanguageSkill {Level = 2, Language = russian, ExpertProfile = ExpertProfile15};
            var russianThree = new LanguageSkill {Level = 3, Language = russian, ExpertProfile = ExpertProfile10};
            //var slovakOne = new LanguageSkill {Level = 1, Language = slovak, ExpertProfile = ExpertProfile1};
            var slovakTwo = new LanguageSkill {Level = 2, Language = slovak, ExpertProfile = ExpertProfile1};
            var slovakThree = new LanguageSkill {Level = 3, Language = slovak, ExpertProfile = ExpertProfile2};
            //var czechOne = new LanguageSkill {Level = 1, Language = czech, ExpertProfile = ExpertProfile4};
            var czechTwo = new LanguageSkill {Level = 2, Language = czech, ExpertProfile = ExpertProfile6};
            var czechThree = new LanguageSkill {Level = 3, Language = czech, ExpertProfile = ExpertProfile7};
            var turkishOne = new LanguageSkill {Level = 1, Language = turkish, ExpertProfile = ExpertProfile8};
            var turkishTwo = new LanguageSkill {Level = 2, Language = turkish, ExpertProfile = ExpertProfile9};
            //var turkishThree = new LanguageSkill {Level = 3, Language = turkish, ExpertProfile = ExpertProfile1};
            //var swedishOne = new LanguageSkill {Level = 1, Language = swedish, ExpertProfile = ExpertProfile1};
            //var swedishTwo = new LanguageSkill {Level = 2, Language = swedish, ExpertProfile = ExpertProfile1};
            var swedishThree = new LanguageSkill {Level = 3, Language = swedish, ExpertProfile = ExpertProfile19};
            var ukrainianOne = new LanguageSkill {Level = 1, Language = ukrainian, ExpertProfile = ExpertProfile21};
            var ukrainianTwo = new LanguageSkill {Level = 2, Language = ukrainian, ExpertProfile = ExpertProfile24};
            //var ukrainianThree = new LanguageSkill {Level = 3, Language = ukrainian, ExpertProfile = ExpertProfile1};


            new List<LanguageSkill>
                {
                    slovenianOne,
                    //arabicTwo,
                    //arabicThree,
                    //bulgarianOne,
                    bulgarianThree,
                    //bulgarianTwo,
                    //chineseOne,
                    //chineseThree,
                    albanianTwo,
                    //danishOne,
                    //danishThree,
                    //danishTwo,
                    englishThree,
                    englishOne,
                    englishTwo,
                    //finnishOne,
                    //finnishThree,
                    finnishTwo,
                    frenchOne,
                    //frenchThree,
                    frenchTwo,
                    italianOne,
                    italianThree,
                    italianTwo,
                    germanTwo,
                    germanOne,
                    germanThree,
                    //greekOne,
                    greekThree,
                    greekTwo,
                    //hungarianOne,
                    hungarianThree,
                    //hungarianTwo,
                    //hindiOne,
                    //hindiTwo,
                    //hindiThree,
                    //japaneseOne,
                    serbianThree,
                    serbianTwo,
                    //dutchOne,
                    //dutchThree,
                    dutchTwo,
                    norwegianOne,
                    //norwegianThree,
                    //norwegianTwo,
                    //persianTwo,
                    //persianThree,
                    //persianOne,
                    //portugueseOne,
                    portugueseThree,
                    portugueseTwo,
                    //polishOne,
                    polishThree,
                    polishTwo,
                    //romanianOne,
                    romanianThree,
                    romanianTwo,
                    russianOne,
                    russianThree,
                    russianTwo,
                    slovakTwo,
                    slovakThree,
                    //slovakOne,
                    //czechOne,
                    czechThree,
                    czechTwo,
                    turkishOne,
                    //turkishThree,
                    turkishTwo,
                    //swedishTwo,
                    swedishThree,
                    //swedishOne,
                    ukrainianOne,
                    //ukrainianThree,
                    ukrainianTwo
                }.ForEach(l => context.LanguageSkills.AddOrUpdate(l));


            //TECHNOLOGIES
            var tech1 = new Technology
                            {
                                Name = "ASP.NET",
                                Industry = educationIndustry
                            };
            var tech2 = new Technology
                            {
                                Name = "JAVA",
                                Industry = educationIndustry
                            };
            var tech3 = new Technology
                            {
                                Name = "Java Script",
                                Industry = educationIndustry
                            };
            var tech4 = new Technology
                            {
                                Name = "PHP",
                                Industry = educationIndustry
                            };
            var tech5 = new Technology
                            {
                                Name = "Ruby on Rails",
                                Industry = educationIndustry
                            };

            new List<Technology>
                {
                    tech1,
                    tech2,
                    tech3,
                    tech4,
                    tech5
                }.ForEach(t => context.Technologies.AddOrUpdate(t));

            //TECHNOLOGY SKILLS
            //Asp.Net
            var aspNetBasic1 = new TechnologySkill
                                   {
                                       Technology = tech1,
                                       Level = 1,
                                       Experience = 1,
                                       ExpertProfile = ExpertProfile1
                                   };
            //var aspNetBasic2 = new TechnologySkill
            //                       {
            //                           Technology = tech1,
            //                           ExpertProfile = ExpertProfile1,
            //                           Level = 1,
            //                           Experience = 2
            //                       };
            //var aspNetBasic3 = new TechnologySkill
            //                       {
            //                           Technology = tech1,
            //                           ExpertProfile = ExpertProfile1,
            //                           Level = 1,
            //                           Experience = 3
            //                       };
            //var aspNetIntermediate1 = new TechnologySkill
            //                              {
            //                                  Technology = tech1,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 2,
            //                                  Experience = 1
            //                              };
            //var aspNetIntermediate2 = new TechnologySkill
            //                              {
            //                                  Technology = tech1,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 2,
            //                                  Experience = 2
            //                              };
            //var aspNetIntermediate3 = new TechnologySkill
            //                              {
            //                                  Technology = tech1,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 2,
            //                                  Experience = 3
            //                              };
            //var aspNetAdvanced1 = new TechnologySkill
            //                          {
            //                              Technology = tech1,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 3,
            //                              Experience = 1
            //                          };
            //var aspNetAdvanced2 = new TechnologySkill
            //                          {
            //                              Technology = tech1,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 3,
            //                              Experience = 2
            //                          };
            //var aspNetAdvanced3 = new TechnologySkill
            //                          {
            //                              Technology = tech1,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 3,
            //                              Experience = 3
            //                          };
            //var aspNetProficient1 = new TechnologySkill
            //                            {
            //                                Technology = tech1,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 4,
            //                                Experience = 1
            //                            };
            //var aspNetProficient2 = new TechnologySkill
            //                            {
            //                                Technology = tech1,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 4,
            //                                Experience = 2
            //                            };
            //var aspNetProficient3 = new TechnologySkill
            //                            {
            //                                Technology = tech1,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 4,
            //                                Experience = 3
            //                            };
            //var aspNetProfessional1 = new TechnologySkill
            //                              {
            //                                  Technology = tech1,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 5,
            //                                  Experience = 1
            //                              };
            //var aspNetProfessional2 = new TechnologySkill
            //                              {
            //                                  Technology = tech1,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 5,
            //                                  Experience = 2
            //                              };
            var aspNetProfessional3 = new TechnologySkill
                                          {
                                              Technology = tech1,
                                              ExpertProfile = ExpertProfile2,
                                              Level = 5,
                                              Experience = 3
                                          };

            //JavaScript
            var javaScriptBasic1 = new TechnologySkill
                                       {
                                           Technology = tech3,
                                           ExpertProfile = ExpertProfile2,
                                           Level = 1,
                                           Experience = 1
                                       };
            var javaScriptBasic2 = new TechnologySkill
                                       {
                                           Technology = tech3,
                                           ExpertProfile = ExpertProfile3,
                                           Level = 1,
                                           Experience = 2
                                       };
            //var javaScriptBasic3 = new TechnologySkill
            //                           {
            //                               Technology = tech3,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 1,
            //                               Experience = 3
            //                           };
            //var javaScriptIntermediate1 = new TechnologySkill
            //                                  {
            //                                      Technology = tech3,
            //                                      ExpertProfile = ExpertProfile1,
            //                                      Level = 2,
            //                                      Experience = 1
            //                                  };
            //var javaScriptIntermediate2 = new TechnologySkill
            //                                  {
            //                                      Technology = tech3,
            //                                      ExpertProfile = ExpertProfile1,
            //                                      Level = 2,
            //                                      Experience = 2
            //                                  };
            //var javaScriptIntermediate3 = new TechnologySkill
            //                                  {
            //                                      Technology = tech3,
            //                                      ExpertProfile = ExpertProfile1,
            //                                      Level = 2,
            //                                      Experience = 3
            //                                  };
            //var javaScriptAdvanced1 = new TechnologySkill
            //                              {
            //                                  Technology = tech3,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 3,
            //                                  Experience = 1
            //                              };
            //var javaScriptAdvanced2 = new TechnologySkill
            //                              {
            //                                  Technology = tech3,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 3,
            //                                  Experience = 2
            //                              };
            //var javaScriptAdvanced3 = new TechnologySkill
            //                              {
            //                                  Technology = tech3,
            //                                  ExpertProfile = ExpertProfile1,
            //                                  Level = 3,
            //                                  Experience = 3
            //                              };
            //var javaScriptProficient1 = new TechnologySkill
            //                                {
            //                                    Technology = tech3,
            //                                    ExpertProfile = ExpertProfile1,
            //                                    Level = 4,
            //                                    Experience = 1
            //                                };
            //var javaScriptProficient2 = new TechnologySkill
            //                                {
            //                                    Technology = tech3,
            //                                    ExpertProfile = ExpertProfile1,
            //                                    Level = 4,
            //                                    Experience = 2
            //                                };
            //var javaScriptProficient3 = new TechnologySkill
            //                                {
            //                                    Technology = tech3,
            //                                    ExpertProfile = ExpertProfile1,
            //                                    Level = 4,
            //                                    Experience = 3
            //                                };
            //var javaScriptProfessional1 = new TechnologySkill
            //                                  {
            //                                      Technology = tech3,
            //                                      ExpertProfile = ExpertProfile1,
            //                                      Level = 5,
            //                                      Experience = 1
            //                                  };
            //var javaScriptProfessional2 = new TechnologySkill
            //                                  {
            //                                      Technology = tech3,
            //                                      ExpertProfile = ExpertProfile1,
            //                                      Level = 5,
            //                                      Experience = 2
            //                                  };
            //var javaScriptProfessional3 = new TechnologySkill
            //                                  {
            //                                      Technology = tech3,
            //                                      ExpertProfile = ExpertProfile1,
            //                                      Level = 5,
            //                                      Experience = 3
            //                                  };

            //Java
            //var javaBasic1 = new TechnologySkill
            //                     {
            //                         Technology = tech2,
            //                         ExpertProfile = ExpertProfile1,
            //                         Level = 1,
            //                         Experience = 1
            //                     };
            //var javaBasic2 = new TechnologySkill
            //                     {
            //                         Technology = tech2,
            //                         ExpertProfile = ExpertProfile1,
            //                         Level = 1,
            //                         Experience = 2
            //                     };
            //var javaBasic3 = new TechnologySkill
            //                     {
            //                         Technology = tech2,
            //                         ExpertProfile = ExpertProfile1,
            //                         Level = 1,
            //                         Experience = 3
            //                     };
            //var javaIntermediate1 = new TechnologySkill
            //                            {
            //                                Technology = tech2,
            //                                ExpertProfile = ExpertProfile4,
            //                                Level = 2,
            //                                Experience = 1
            //                            };
            //var javaIntermediate2 = new TechnologySkill
            //                            {
            //                                Technology = tech2,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 2,
            //                                Experience = 2
            //                            };
            //var javaIntermediate3 = new TechnologySkill
            //                            {
            //                                Technology = tech2,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 2,
            //                                Experience = 3
            //                            };
            //var javaAdvanced1 = new TechnologySkill
            //                        {
            //                            Technology = tech2,
            //                            ExpertProfile = ExpertProfile1,
            //                            Level = 3,
            //                            Experience = 1
            //                        };
            //var javaAdvanced2 = new TechnologySkill
            //                        {
            //                            Technology = tech2,
            //                            ExpertProfile = ExpertProfile1,
            //                            Level = 3,
            //                            Experience = 2
            //                        };
            //var javaAdvanced3 = new TechnologySkill
            //                        {
            //                            Technology = tech2,
            //                            ExpertProfile = ExpertProfile1,
            //                            Level = 3,
            //                            Experience = 3
            //                        };
            //var javaProficient1 = new TechnologySkill
            //                          {
            //                              Technology = tech2,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 4,
            //                              Experience = 1
            //                          };
            //var javaProficient2 = new TechnologySkill
            //                          {
            //                              Technology = tech2,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 4,
            //                              Experience = 2
            //                          };
            //var javaProficient3 = new TechnologySkill
            //                          {
            //                              Technology = tech2,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 4,
            //                              Experience = 3
            //                          };
            //var javaProfessional1 = new TechnologySkill
            //                            {
            //                                Technology = tech2,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 5,
            //                                Experience = 1
            //                            };
            var javaProfessional2 = new TechnologySkill
                                        {
                                            Technology = tech2,
                                            ExpertProfile = ExpertProfile4,
                                            Level = 5,
                                            Experience = 2
                                        };
            var javaProfessional3 = new TechnologySkill
                                        {
                                            Technology = tech2,
                                            ExpertProfile = ExpertProfile1,
                                            Level = 5,
                                            Experience = 3
                                        };

            //Php
            var phpBasic1 = new TechnologySkill
                                {
                                    Technology = tech4,
                                    ExpertProfile = ExpertProfile2,
                                    Level = 1,
                                    Experience = 1
                                };
            var phpBasic2 = new TechnologySkill
                                {
                                    Technology = tech4,
                                    ExpertProfile = ExpertProfile3,
                                    Level = 1,
                                    Experience = 2
                                };
            //var phpBasic3 = new TechnologySkill
            //                    {
            //                        Technology = tech4,
            //                        ExpertProfile = ExpertProfile1,
            //                        Level = 1,
            //                        Experience = 3
            //                    };
            //var phpIntermediate1 = new TechnologySkill
            //                           {
            //                               Technology = tech4,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 2,
            //                               Experience = 1
            //                           };
            //var phpIntermediate2 = new TechnologySkill
            //                           {
            //                               Technology = tech4,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 2,
            //                               Experience = 2
            //                           };
            //var phpIntermediate3 = new TechnologySkill
            //                           {
            //                               Technology = tech4,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 2,
            //                               Experience = 3
            //                           };
            //var phpAdvanced1 = new TechnologySkill
            //                       {
            //                           Technology = tech4,
            //                           ExpertProfile = ExpertProfile1,
            //                           Level = 3,
            //                           Experience = 1
            //                       };
            //var phpAdvanced2 = new TechnologySkill
            //                       {
            //                           Technology = tech4,
            //                           ExpertProfile = ExpertProfile1,
            //                           Level = 3,
            //                           Experience = 2
            //                       };
            //var phpAdvanced3 = new TechnologySkill
            //                       {
            //                           Technology = tech4,
            //                           ExpertProfile = ExpertProfile1,
            //                           Level = 3,
            //                           Experience = 3
            //                       };
            //var phpProficient1 = new TechnologySkill
            //                         {
            //                             Technology = tech4,
            //                             ExpertProfile = ExpertProfile1,
            //                             Level = 4,
            //                             Experience = 1
            //                         };
            //var phpProficient2 = new TechnologySkill
            //                         {
            //                             Technology = tech4,
            //                             ExpertProfile = ExpertProfile1,
            //                             Level = 4,
            //                             Experience = 2
            //                         };
            //var phpProficient3 = new TechnologySkill
            //                         {
            //                             Technology = tech4,
            //                             ExpertProfile = ExpertProfile1,
            //                             Level = 4,
            //                             Experience = 3
            //                         };
            //var phpProfessional1 = new TechnologySkill
            //                           {
            //                               Technology = tech4,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 5,
            //                               Experience = 1
            //                           };
            //var phpProfessional2 = new TechnologySkill
            //                           {
            //                               Technology = tech4,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 5,
            //                               Experience = 2
            //                           };
            //var phpProfessional3 = new TechnologySkill
            //                           {
            //                               Technology = tech4,
            //                               ExpertProfile = ExpertProfile1,
            //                               Level = 5,
            //                               Experience = 3
            //                           };

            //RubyOnRails
            var rubyBasic1 = new TechnologySkill
                                 {
                                     Technology = tech5,
                                     ExpertProfile = ExpertProfile1,
                                     Level = 1,
                                     Experience = 1
                                 };
            var rubyBasic2 = new TechnologySkill
                                 {
                                     Technology = tech5,
                                     ExpertProfile = ExpertProfile4,
                                     Level = 1,
                                     Experience = 2
                                 };
            var rubyBasic3 = new TechnologySkill
                                 {
                                     Technology = tech5,
                                     ExpertProfile = ExpertProfile2,
                                     Level = 1,
                                     Experience = 3
                                 };
            //var rubyIntermediate1 = new TechnologySkill
            //                            {
            //                                Technology = tech5,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 2,
            //                                Experience = 1
            //                            };
            //var rubyIntermediate2 = new TechnologySkill
            //                            {
            //                                Technology = tech5,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 2,
            //                                Experience = 2
            //                            };
            //var rubyIntermediate3 = new TechnologySkill
            //                            {
            //                                Technology = tech5,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 2,
            //                                Experience = 3
            //                            };
            //var rubyAdvanced1 = new TechnologySkill
            //                        {
            //                            Technology = tech5,
            //                            ExpertProfile = ExpertProfile1,
            //                            Level = 3,
            //                            Experience = 1
            //                        };
            //var rubyAdvanced2 = new TechnologySkill
            //                        {
            //                            Technology = tech5,
            //                            ExpertProfile = ExpertProfile1,
            //                            Level = 3,
            //                            Experience = 2
            //                        };
            //var rubyAdvanced3 = new TechnologySkill
            //                        {
            //                            Technology = tech5,
            //                            ExpertProfile = ExpertProfile1,
            //                            Level = 3,
            //                            Experience = 3
            //                        };
            //var rubyProficient1 = new TechnologySkill
            //                          {
            //                              Technology = tech5,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 4,
            //                              Experience = 1
            //                          };
            //var rubyProficient2 = new TechnologySkill
            //                          {
            //                              Technology = tech5,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 4,
            //                              Experience = 2
            //                          };
            //var rubyProficient3 = new TechnologySkill
            //                          {
            //                              Technology = tech5,
            //                              ExpertProfile = ExpertProfile1,
            //                              Level = 4,
            //                              Experience = 3
            //                          };
            //var rubyProfessional1 = new TechnologySkill
            //                            {
            //                                Technology = tech5,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 5,
            //                                Experience = 1
            //                            };
            //var rubyProfessional2 = new TechnologySkill
            //                            {
            //                                Technology = tech5,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 5,
            //                                Experience = 2
            //                            };
            //var rubyProfessional3 = new TechnologySkill
            //                            {
            //                                Technology = tech5,
            //                                ExpertProfile = ExpertProfile1,
            //                                Level = 5,
            //                                Experience = 3
            //                            };

            new List<TechnologySkill>
                {
                    //aspNetAdvanced1,
                    //aspNetAdvanced2,
                    //aspNetAdvanced3,
                    aspNetBasic1,
                    //aspNetBasic2,
                    //aspNetBasic3,
                    //aspNetIntermediate1,
                    //aspNetIntermediate2,
                    //aspNetIntermediate3,
                    //aspNetProfessional1,
                    //aspNetProfessional2,
                    aspNetProfessional3,
                    //aspNetProficient1,
                    //aspNetProficient2,
                    //aspNetProficient3,
                    //javaAdvanced1,
                    //javaAdvanced2,
                    //javaAdvanced3,
                    //javaBasic1,
                    //javaBasic2,
                    //javaBasic3,
                    //javaIntermediate1,
                    //javaIntermediate2,
                    //javaIntermediate3,
                    //javaProfessional1,
                    javaProfessional2,
                    javaProfessional3,
                    //javaProficient1,
                    //javaProficient2,
                    //javaProficient3,
                    //javaScriptAdvanced1,
                    //javaScriptAdvanced2,
                    //javaScriptAdvanced3,
                    javaScriptBasic1,
                    javaScriptBasic2,
                    //javaScriptBasic3,
                    //javaScriptIntermediate1,
                    //javaScriptIntermediate2,
                    //javaScriptIntermediate3,
                    //javaScriptProfessional1,
                    //javaScriptProfessional2,
                    //javaScriptProfessional3,
                    //javaScriptProficient1,
                    //javaScriptProficient2,
                    //javaScriptProficient3,
                    //phpAdvanced1,
                    //phpAdvanced2,
                    //phpAdvanced3,
                    phpBasic1,
                    phpBasic2,
                    //phpBasic3,
                    //phpIntermediate1,
                    //phpIntermediate2,
                    //phpIntermediate3,
                    //phpProfessional1,
                    //phpProfessional2,
                    //phpProfessional3,
                    //phpProficient1,
                    //phpProficient2,
                    //phpProficient3,
                    //rubyAdvanced1,
                    //rubyAdvanced2,
                    //rubyAdvanced3,
                    rubyBasic1,
                    rubyBasic2,
                    rubyBasic3,
                    //rubyIntermediate1,
                    //rubyIntermediate2,
                    //rubyIntermediate3,
                    //rubyProfessional1,
                    //rubyProfessional2,
                    //rubyProfessional3,
                    //rubyProficient1,
                    //rubyProficient2,
                    //rubyProficient3
                }.ForEach(ts => context.TechnologySkills.AddOrUpdate(ts));

            //COMPANY PROFILES
            var companyProfile1 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Software Design",
                                          TagLine = "tag",
                                          Description = "We design software solutions",
                                          Website = "http://www.softwaredesign.com",
                                          Location = "Rome",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user1,
                                          Country = italy,
                                          Industry = informationAndCommunicationIndustry,
                                          Categories =
                                              new List<Category>
                                                  {SoftwareDevelopment, SoftwareArchitect, SoftwareDeveloper},
                                          Technologies = new List<Technology> {tech1, tech2}
                                      };
            var companyProfile2 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Database Administrations",
                                          TagLine = "tag",
                                          Description = "We are DB administrators",
                                          Website = "http://www.db.com",
                                          Location = "Berlin",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user2,
                                          Country = germany,
                                          Industry = educationIndustry,
                                          Categories =
                                              new List<Category>
                                                  {DatabaseDeveloper, DatabaseAdministrator, DataProtectionOfficer},
                                          Technologies = new List<Technology> {tech3, tech4}
                                      };
            var companyProfile3 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Networks",
                                          TagLine = "tag",
                                          Description = "All about networks",
                                          Website = "http://www.networksforyou.com",
                                          Location = "Praga",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user3,
                                          Country = czechRepublic,
                                          Industry = educationIndustry,
                                          Categories = new List<Category> {NetworkAdministrator, NetworkPlanner},
                                          Technologies = new List<Technology> {tech3, tech4}
                                      };
            var companyProfile4 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Web Design",
                                          TagLine = "tag",
                                          Description = "It's all about the web",
                                          Website = "http://www.webwebweb.com",
                                          Location = "Paris",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user4,
                                          Country = france,
                                          Industry = creativeIndustry,
                                          Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                          Technologies = new List<Technology> {tech5, tech4}
                                      };
            var companyProfile5 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Computer Logistics",
                                          TagLine = "tag",
                                          Description = "It's all about the web",
                                          Website = "http://www.webwebweb.com",
                                          Location = "Paris",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user4,
                                          Country = france,
                                          Industry = creativeIndustry,
                                          Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                          Technologies = new List<Technology> {tech5, tech4}
                                      };
            var companyProfile6 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Software Solutions",
                                          TagLine = "tag",
                                          Description = "We design software solutions",
                                          Website = "http://www.softwaredesign.com",
                                          Location = "Krems",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user1,
                                          Country = austria,
                                          Industry = informationAndCommunicationIndustry,
                                          Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                          Technologies = new List<Technology> {tech5, tech4}
                                      };
            var companyProfile7 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "Devian DB",
                                          TagLine = "tag",
                                          Description = "We are DB administrators",
                                          Website = "http://www.db.com",
                                          Location = "Vienna",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user2,
                                          Country = austria,
                                          Industry = educationIndustry,
                                          Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                          Technologies = new List<Technology> {tech5, tech4}
                                      };
            var companyProfile8 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "NetworkNet",
                                          TagLine = "tag",
                                          Description = "All about networks",
                                          Website = "http://www.networksforyou.com",
                                          Location = "London",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user3,
                                          Country = unitedKingdom,
                                          Industry = educationIndustry,
                                          Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                          Technologies = new List<Technology> {tech5, tech4}
                                      };
            var companyProfile9 = new CompanyProfile
                                      {
                                          IsDefault = false,
                                          Title = "WebWebWeb",
                                          TagLine = "tag",
                                          Description = "It's all about the web",
                                          Website = "http://www.webwebweb.com",
                                          Location = "Venezia",
                                          Photo = "../../Content/img/250X250_company_icon.png",
                                          Email = "gorgieva_sandra@yahoo.com",
                                          PhoneNumber = "00389070333555",
                                          User = user4,
                                          Country = italy,
                                          Industry = creativeIndustry,
                                          Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                          Technologies = new List<Technology> {tech5, tech4}
                                      };
            var companyProfile10 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "Webus",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Berlin",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = germany,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile11 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "SoftwareHack",
                                           TagLine = "tag",
                                           Description = "We design software solutions",
                                           Website = "http://www.softwaredesign.com",
                                           Location = "Rome",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user1,
                                           Country = italy,
                                           Industry = informationAndCommunicationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile12 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "DataDesign",
                                           TagLine = "tag",
                                           Description = "We are DB administrators",
                                           Website = "http://www.db.com",
                                           Location = "Graz",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user2,
                                           Country = austria,
                                           Industry = educationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile13 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "NetDesign",
                                           TagLine = "tag",
                                           Description = "All about networks",
                                           Website = "http://www.networksforyou.com",
                                           Location = "Bratislava",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user3,
                                           Country = slovakia,
                                           Industry = educationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile14 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "WebArt",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Skopje",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = macedonia,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile15 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "IdeaPlus",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Vienna",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = austria,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile16 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "Solution+",
                                           TagLine = "tag",
                                           Description = "We design software solutions",
                                           Website = "http://www.softwaredesign.com",
                                           Location = "Istanbul",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user1,
                                           Country = turkey,
                                           Industry = informationAndCommunicationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile17 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "DataD",
                                           TagLine = "tag",
                                           Description = "We are DB administrators",
                                           Website = "http://www.db.com",
                                           Location = "Berlin",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user2,
                                           Country = germany,
                                           Industry = educationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile18 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "NetworkVirtual",
                                           TagLine = "tag",
                                           Description = "All about networks",
                                           Website = "http://www.networksforyou.com",
                                           Location = "Warsaw",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user3,
                                           Country = poland,
                                           Industry = educationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile19 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "WebPolio",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Warsaw",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = poland,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {ITAuditor, ITConsultant},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile20 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "Design+",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Hamburg",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = germany,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {ITSecurityManager, ITAuditor},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile21 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "SoftwareArk",
                                           TagLine = "tag",
                                           Description = "We design software solutions",
                                           Website = "http://www.softwaredesign.com",
                                           Location = "Frankfurt",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user1,
                                           Country = germany,
                                           Industry = informationAndCommunicationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile22 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "DbWorld",
                                           TagLine = "tag",
                                           Description = "We are DB administrators",
                                           Website = "http://www.db.com",
                                           Location = "Zagreb",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user2,
                                           Country = croatia,
                                           Industry = educationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile23 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "NetworkWorld",
                                           TagLine = "tag",
                                           Description = "All about networks",
                                           Website = "http://www.networksforyou.com",
                                           Location = "Belgrade",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user3,
                                           Country = serbia,
                                           Industry = educationIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile24 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "WebPlace",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Podgorica",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = montenegro,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };
            var companyProfile25 = new CompanyProfile
                                       {
                                           IsDefault = false,
                                           Title = "CompanyExtra",
                                           TagLine = "tag",
                                           Description = "It's all about the web",
                                           Website = "http://www.webwebweb.com",
                                           Location = "Berlin",
                                           Photo = "../../Content/img/250X250_company_icon.png",
                                           Email = "gorgieva_sandra@yahoo.com",
                                           PhoneNumber = "00389070333555",
                                           User = user4,
                                           Country = germany,
                                           Industry = creativeIndustry,
                                           Categories = new List<Category> {WebDesigner, WebDeveloper, Webmaster},
                                           Technologies = new List<Technology> {tech5, tech4}
                                       };

            new List<CompanyProfile>
                {
                    companyProfile1,
                    companyProfile2,
                    companyProfile3,
                    companyProfile4,
                    companyProfile5,
                    companyProfile6,
                    companyProfile7,
                    companyProfile8,
                    companyProfile9,
                    companyProfile10,
                    companyProfile11,
                    companyProfile12,
                    companyProfile13,
                    companyProfile14,
                    companyProfile15,
                    companyProfile16,
                    companyProfile17,
                    companyProfile18,
                    companyProfile19,
                    companyProfile20,
                    companyProfile21,
                    companyProfile22,
                    companyProfile23,
                    companyProfile24,
                    companyProfile25,
                }.ForEach(c => context.CompanyProfiles.AddOrUpdate(c));

            //Positions
            var project1 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Desctop application",
                                   Description = "this is app for financials",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "1 month",
                                   Location = "Vienna",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {DatabaseAdministrator},
                                   Technologies = new List<Technology> {tech1, tech3},
                                   Country = austria,
                                   CompanyProfile = companyProfile1,
                                   Industry = educationIndustry
                               };
            var project2 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Web application",
                                   Description = "this is app for website",
                                   StartDate = new DateTime(2012, 12, 20),
                                   Duration = "1 month",
                                   Location = "Milano",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {UnixAdministrator},
                                   Technologies = new List<Technology> {tech5},
                                   Country = italy,
                                   CompanyProfile = companyProfile1,
                                   Industry = educationIndustry
                               };
            var project3 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Android application",
                                   Description = "this is android appliaction",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "2 months",
                                   Location = "Bratislava",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {WindowsAdministrator},
                                   Technologies = new List<Technology> {tech4, tech3},
                                   Country = slovakia,
                                   CompanyProfile = companyProfile2,
                                   Industry = educationIndustry
                               };
            var project4 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Desctop application",
                                   Description = "this is app for financials",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "1 month",
                                   Location = "Frankfurt",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {Tester},
                                   Technologies = new List<Technology> {tech2},
                                   Country = germany,
                                   CompanyProfile = companyProfile3,
                                   Industry = educationIndustry
                               };
            var project5 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Web site for bank",
                                   Description = "this is  web site for financials",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "3 month",
                                   Location = "Berlin",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {SystemDeveloper},
                                   Technologies = new List<Technology> {tech2},
                                   Country = germany,
                                   CompanyProfile = companyProfile4,
                                   Industry = educationIndustry
                               };
            var project6 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Desctop application",
                                   Description = "this is app for financials",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "1 month",
                                   Location = "Bratislava",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 0,
                                   Categories = new List<Category> {ITConsultant},
                                   Technologies = new List<Technology> {tech1, tech3},
                                   Country = slovakia,
                                   CompanyProfile = companyProfile5,
                                   Industry = educationIndustry
                               };
            var project7 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Seventh application",
                                   Description = "this is app for financials",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "1 month",
                                   Location = "Vienna",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {DatabaseAdministrator},
                                   Technologies = new List<Technology> {tech1, tech3},
                                   Country = austria,
                                   CompanyProfile = companyProfile1,
                                   Industry = educationIndustry
                               };
            var project8 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Web platform",
                                   Description = "this is platform for bla bla",
                                   StartDate = new DateTime(2012, 12, 20),
                                   Duration = "1 month",
                                   Location = "Munich",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {UnixAdministrator},
                                   Technologies = new List<Technology> {tech5},
                                   Country = germany,
                                   CompanyProfile = companyProfile1,
                                   Industry = educationIndustry
                               };
            var project9 = new Position
                               {
                                   IsDefault = false,
                                   Title = "Facebook application",
                                   Description = "this is appliaction for social network Facebook",
                                   StartDate = new DateTime(2012, 10, 25),
                                   Duration = "2 months",
                                   Location = "London",
                                   Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                   JobType = 1,
                                   Categories = new List<Category> {WindowsAdministrator},
                                   Technologies = new List<Technology> {tech4, tech3},
                                   Country = unitedKingdom,
                                   CompanyProfile = companyProfile2,
                                   Industry = educationIndustry
                               };
            var project10 = new Position
                                {
                                    IsDefault = false,
                                    Title = "Desctop application for bank",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Bratislava",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {Tester},
                                    Technologies = new List<Technology> {tech2},
                                    Country = slovakia,
                                    CompanyProfile = companyProfile3,
                                    Industry = educationIndustry
                                };
            var project11 = new Position
                                {
                                    IsDefault = false,
                                    Title = "Web site for bank",
                                    Description = "this is  web site for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "3 month",
                                    Location = "Rome",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {SystemDeveloper},
                                    Technologies = new List<Technology> {tech2},
                                    Country = italy,
                                    CompanyProfile = companyProfile4,
                                    Industry = educationIndustry
                                };
            var project12 = new Position
                                {
                                    IsDefault = false,
                                    Title = "Desctop application",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Brisel",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 0,
                                    Categories = new List<Category> {ITConsultant},
                                    Technologies = new List<Technology> {tech1, tech3},
                                    Country = germany,
                                    CompanyProfile = companyProfile5,
                                    Industry = educationIndustry
                                };
            var project13 = new Position
                                {
                                    IsDefault = false,
                                    Title = "13th Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Graz",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {DatabaseAdministrator},
                                    Technologies = new List<Technology> {tech1, tech3},
                                    Country = austria,
                                    CompanyProfile = companyProfile1,
                                    Industry = educationIndustry
                                };
            var project14 = new Position
                                {
                                    IsDefault = false,
                                    Title = "14th Position",
                                    Description = "this is app for website",
                                    StartDate = new DateTime(2012, 12, 20),
                                    Duration = "1 month",
                                    Location = "Skopje",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {UnixAdministrator},
                                    Technologies = new List<Technology> {tech5},
                                    Country = macedonia,
                                    CompanyProfile = companyProfile1,
                                    Industry = educationIndustry
                                };
            var project15 = new Position
                                {
                                    IsDefault = false,
                                    Title = "15th Position",
                                    Description = "this is android appliaction",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "2 months",
                                    Location = "Belgrade",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {WindowsAdministrator},
                                    Technologies = new List<Technology> {tech4, tech3},
                                    Country = serbia,
                                    CompanyProfile = companyProfile2,
                                    Industry = educationIndustry
                                };
            var project16 = new Position
                                {
                                    IsDefault = false,
                                    Title = "16th Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Paris",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {Tester},
                                    Technologies = new List<Technology> {tech2},
                                    Country = france,
                                    CompanyProfile = companyProfile3,
                                    Industry = educationIndustry
                                };
            var project17 = new Position
                                {
                                    IsDefault = false,
                                    Title = "17th Position",
                                    Description = "this is  web site for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "3 month",
                                    Location = "Istanbul",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {SystemDeveloper},
                                    Technologies = new List<Technology> {tech2},
                                    Country = turkey,
                                    CompanyProfile = companyProfile4,
                                    Industry = educationIndustry
                                };
            var project18 = new Position
                                {
                                    IsDefault = false,
                                    Title = "18th Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Brisel",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 0,
                                    Categories = new List<Category> {ITConsultant},
                                    Technologies = new List<Technology> {tech1, tech3},
                                    Country = germany,
                                    CompanyProfile = companyProfile5,
                                    Industry = educationIndustry
                                };
            var project19 = new Position
                                {
                                    IsDefault = false,
                                    Title = "19th Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Warsaw",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {DatabaseAdministrator},
                                    Technologies = new List<Technology> {tech1, tech3},
                                    Country = poland,
                                    CompanyProfile = companyProfile1,
                                    Industry = educationIndustry
                                };
            var project20 = new Position
                                {
                                    IsDefault = false,
                                    Title = "20th Position",
                                    Description = "this is platform for bla bla",
                                    StartDate = new DateTime(2012, 12, 20),
                                    Duration = "1 month",
                                    Location = "Munich",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {UnixAdministrator},
                                    Technologies = new List<Technology> {tech5},
                                    Country = germany,
                                    CompanyProfile = companyProfile1,
                                    Industry = educationIndustry
                                };
            var project21 = new Position
                                {
                                    IsDefault = false,
                                    Title = "21st Position",
                                    Description = "this is appliaction for social network Facebook",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "2 months",
                                    Location = "London",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {WindowsAdministrator},
                                    Technologies = new List<Technology> {tech4, tech3},
                                    Country = unitedKingdom,
                                    CompanyProfile = companyProfile2,
                                    Industry = educationIndustry
                                };
            var project22 = new Position
                                {
                                    IsDefault = false,
                                    Title = "22nd Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Zagreb",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {Tester},
                                    Technologies = new List<Technology> {tech2},
                                    Country = croatia,
                                    CompanyProfile = companyProfile3,
                                    Industry = educationIndustry
                                };
            var project23 = new Position
                                {
                                    IsDefault = false,
                                    Title = "23th Position",
                                    Description = "this is  web site for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "3 month",
                                    Location = "Rome",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 1,
                                    Categories = new List<Category> {SystemDeveloper},
                                    Technologies = new List<Technology> {tech2},
                                    Country = italy,
                                    CompanyProfile = companyProfile4,
                                    Industry = educationIndustry
                                };
            var project24 = new Position
                                {
                                    IsDefault = false,
                                    Title = "24th Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Brisel",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 0,
                                    Categories = new List<Category> {ITConsultant},
                                    Technologies = new List<Technology> {tech1, tech3},
                                    Country = germany,
                                    CompanyProfile = companyProfile5,
                                    Industry = educationIndustry
                                };
            var project25 = new Position
                                {
                                    IsDefault = false,
                                    Title = "25th Position",
                                    Description = "this is app for financials",
                                    StartDate = new DateTime(2012, 10, 25),
                                    Duration = "1 month",
                                    Location = "Brisel",
                                    Photo = "../../Content/img/250X250_home-project-icon.jpg",
                                    JobType = 0,
                                    Categories = new List<Category> {ITConsultant},
                                    Technologies = new List<Technology> {tech1, tech3},
                                    Country = germany,
                                    CompanyProfile = companyProfile5,
                                    Industry = educationIndustry
                                };

            new List<Position>
                {
                    project1,
                    project2,
                    project3,
                    project4,
                    project5,
                    project6,
                    project7,
                    project8,
                    project9,
                    project10,
                    project11,
                    project12,
                    project13,
                    project14,
                    project15,
                    project16,
                    project17,
                    project18,
                    project19,
                    project20,
                    project21,
                    project22,
                    project23,
                    project24,
                    project25
                }.ForEach(p => context.Positions.AddOrUpdate(p));


            //MESSAGE FOLDER
            var inboxUser1 = new MessageFolder
                                 {
                                     Name = "Inbox",
                                     FolderType = 0,
                                     Owner = user1
                                 };
            var outboxUser1 = new MessageFolder
                                  {
                                      Name = "Outbox",
                                      FolderType = 1,
                                      Owner = user1
                                  };
            var trashUser1 = new MessageFolder
                                 {
                                     Name = "Trash",
                                     FolderType = 2,
                                     Owner = user1
                                 };
            var publicUser1 = new MessageFolder
                                  {
                                      Name = "Public",
                                      FolderType = 3,
                                      Owner = user1
                                  };
            var inboxUser2 = new MessageFolder
                                 {
                                     Name = "Inbox",
                                     FolderType = 0,
                                     Owner = user2
                                 };
            var outboxUser2 = new MessageFolder
                                  {
                                      Name = "Outbox",
                                      FolderType = 1,
                                      Owner = user2
                                  };
            var trashUser2 = new MessageFolder
                                 {
                                     Name = "Trash",
                                     FolderType = 2,
                                     Owner = user2
                                 };
            var publicUser2 = new MessageFolder
                                  {
                                      Name = "Public",
                                      FolderType = 3,
                                      Owner = user2
                                  };
            new List<MessageFolder>
                {
                    inboxUser1,
                    outboxUser1,
                    trashUser1,
                    publicUser1,
                    inboxUser2,
                    outboxUser2,
                    trashUser2,
                    publicUser2
                }.ForEach(m => context.MessageFolders.AddOrUpdate(m));


            //MESSAGE
            var message1OutboxUser1InboxUser2 = new Message
                                                    {
                                                        Subject = "Application for Position",
                                                        Body =
                                                            "Dear Mr and mrs," +
                                                            " I am interested to work on your project. " +
                                                            "Please see my qualifications and contact me ASAP. " +
                                                            "We are building an online marketplace that will change the way local merchants sell and connect with their customers. " +
                                                            "We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) " +
                                                            "We are building an online marketplace that will change the way local merchants sell and connect with their customers." +
                                                            "We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...)"
                                                    };
            var message1OutboxUser1InboxUser2Child1 = new Message
                                                          {
                                                              Subject = "Application for Position",
                                                              Body =
                                                                  "Dear Mr/Mrs, " +
                                                                  "first thank you vey much for your interest on our Position. " +
                                                                  "We reviewed your profile and qualifications and we are interested to make you and interview. " +
                                                                  "Can you please come to our offices on the followinf date and time: .... so we can make you an interview." +
                                                                  "" +
                                                                  "Please confirm your presence. " +
                                                                  "Thank you. " +
                                                                  "" +
                                                                  "Sincerely...",
                                                              Parent = message1OutboxUser1InboxUser2
                                                          };
            var message1OutboxUser1InboxUser2Child2 = new Message
                                                          {
                                                              Subject = "Application for Position",
                                                              Body =
                                                                  "Dear Mr and mrs, " +
                                                                  "I am confirming my presence on the interview. " +
                                                                  "" +
                                                                  "Thank you very much. " +
                                                                  "See you there. " +
                                                                  "" +
                                                                  "Sincerely ....",
                                                              Parent = message1OutboxUser1InboxUser2
                                                          };
            var message2OutboxUser1InboxUser2 = new Message
                                                    {
                                                        Subject = "Information for your Position",
                                                        Body =
                                                            "Dear Mr and mrs, I am interested for more information about the location and duration of the Position. Can someone please give me detailed schedule. We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) Thank you.",
                                                    };
            var message3OutboxUser1InboxUser2 = new Message
                                                    {
                                                        Subject = "Invitation for conference",
                                                        Body =
                                                            "Dear Mr and Mrs, We are invating your company, to take part of our conference. We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) Thank you. Sincerely...",
                                                    };
            var message4OutboxUser1InboxUser2 = new Message
                                                    {
                                                        Subject = "Job Offer",
                                                        Body =
                                                            "Dear Mr/Mrs ...,our Hr team reviewed your profile on the Xconnected platform and we are interested to make you a job interview if you are also interested for our opened job position." +
                                                            "Please reply as ASAP since we are hiring. We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) Sincerely...",
                                                    };
            var message5InboxUser1OutboxUser2 = new Message
                                                    {
                                                        Subject = "Congratulations, You're accepted",
                                                        Body =
                                                            "Dear Mrs Smith, we are writing you to inform you that your application for our opened job position was accepted.Please contact us ASAP, so we can give you more detailed informations. We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...)",
                                                    };
            var message6InboxUser1OutboxUser2 = new Message
                                                    {
                                                        Subject = "Invitation for another conference",
                                                        Body =
                                                            "Dear Mr and Mrs, We are invating you, to take part of our conference. We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...) Thank you. Sincerely...  ",
                                                    };
            var message7InboxUser1OutboxUser2 = new Message
                                                    {
                                                        Subject = "Some message",
                                                        Body =
                                                            "Some content...We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...). We are building an online marketplace that will change the way local merchants sell and connect with their customers. We are looking for a front-end developer with a serious eye for design to help shape our user experience. You should be just as (...)",
                                                    };
            new List<Message>
                {
                    message1OutboxUser1InboxUser2,
                    message1OutboxUser1InboxUser2Child1,
                    message1OutboxUser1InboxUser2Child2,
                    message2OutboxUser1InboxUser2,
                    message3OutboxUser1InboxUser2,
                    message4OutboxUser1InboxUser2,
                    message5InboxUser1OutboxUser2,
                    message6InboxUser1OutboxUser2,
                    message7InboxUser1OutboxUser2
                }.ForEach(m => context.Messages.AddOrUpdate(m));


            //MESSAGE Expert USER
            var messageExpertUser1 = new MessageExpertUser
                                         {
                                             IsRead = true,
                                             IsStarred = true,
                                             IsSender = true,
                                             Message = message1OutboxUser1InboxUser2,
                                             ExpertProfile = ExpertProfile1,
                                             MessageFolder = outboxUser1
                                         };
            var messageExpertUser2 = new MessageExpertUser
                                         {
                                             IsRead = false,
                                             IsStarred = false,
                                             IsSender = false,
                                             Message = message1OutboxUser1InboxUser2Child1,
                                             ExpertProfile = ExpertProfile1,
                                             MessageFolder = inboxUser1
                                         };
            var messageExpertUser3 = new MessageExpertUser
                                         {
                                             IsRead = true,
                                             IsStarred = true,
                                             IsSender = true,
                                             Message = message1OutboxUser1InboxUser2Child2,
                                             ExpertProfile = ExpertProfile1,
                                             MessageFolder = outboxUser1
                                         };
            var messageExpertUser4 = new MessageExpertUser
                                         {
                                             IsRead = true,
                                             IsStarred = false,
                                             IsSender = true,
                                             Message = message2OutboxUser1InboxUser2,
                                             ExpertProfile = ExpertProfile6,
                                             MessageFolder = outboxUser1
                                         };

            //var messageExpertUser3 = new MessageExpertUser
            //                               {
            //                                   IsRead = false,
            //                                   IsStarred = false,
            //                                   IsSender = false,
            //                                   Message = message4OutboxUser1InboxUser2,
            //                                   ExpertProfile = ExpertProfile22,
            //                                   MessageFolder = inboxUser2
            //                               };
            //var messageExpertUser4 = new MessageExpertUser
            //                               {
            //                                   IsRead = true,
            //                                   IsStarred = true,
            //                                   IsSender = true,
            //                                   Message = message7InboxUser1OutboxUser2,
            //                                   ExpertProfile = ExpertProfile22,
            //                                   MessageFolder = outboxUser2
            //                               };

            //var messageExpertUser5 = new MessageExpertUser
            //                               {
            //                                   IsRead = false,
            //                                   IsStarred = false,
            //                                   IsSender = false,
            //                                   Message = message7InboxUser1OutboxUser2,
            //                                   ExpertProfile = ExpertProfile1,
            //                                   MessageFolder = inboxUser1
            //                               };
            new List<MessageExpertUser>
                {
                    messageExpertUser1,
                    messageExpertUser2,
                    messageExpertUser3,
                    messageExpertUser4
                    //messageExpertUser3,
                    //messageExpertUser4,
                    //messageExpertUser5
                }.ForEach(m => context.MessageExpertUsers.AddOrUpdate(m));

            //MESSAGE COMPANY USER
            var messageCompanyUser1 = new MessageCompanyUser
                                          {
                                              IsRead = true,
                                              IsStarred = true,
                                              IsSender = true,
                                              Message = message3OutboxUser1InboxUser2,
                                              CompanyProfile = companyProfile6,
                                              MessageFolder = outboxUser1
                                          };
            var messageCompanyUser2 = new MessageCompanyUser
                                          {
                                              IsRead = false,
                                              IsStarred = false,
                                              IsSender = false,
                                              Message = message3OutboxUser1InboxUser2,
                                              CompanyProfile = companyProfile2,
                                              MessageFolder = inboxUser2
                                          };
            //var messageCompanyUser3 = new MessageCompanyUser
            //                              {
            //                                  IsRead = true,
            //                                  IsStarred = true,
            //                                  IsSender = true,
            //                                  Message = message4OutboxUser1InboxUser2,
            //                                  CompanyProfile = companyProfile1,
            //                                  MessageFolder = inboxUser1
            //                              };
            //var messageCompanyUser4 = new MessageCompanyUser
            //                              {
            //                                  IsRead = true,
            //                                  IsStarred = true,
            //                                  IsSender = true,
            //                                  Message = message5InboxUser1OutboxUser2,
            //                                  CompanyProfile = companyProfile2,
            //                                  MessageFolder = inboxUser2
            //                              };
            //var messageCompanyUser5 = new MessageCompanyUser
            //                              {
            //                                  IsRead = true,
            //                                  IsStarred = true,
            //                                  IsSender = true,
            //                                  Message = message6InboxUser1OutboxUser2,
            //                                  CompanyProfile = companyProfile2,
            //                                  MessageFolder = outboxUser2
            //                              };
            //var messageCompanyUser6 = new MessageCompanyUser
            //                              {
            //                                  IsRead = false,
            //                                  IsStarred = false,
            //                                  IsSender = false,
            //                                  Message = message6InboxUser1OutboxUser2,
            //                                  CompanyProfile = companyProfile21,
            //                                  MessageFolder = inboxUser1
            //                              };
            new List<MessageCompanyUser>
                {
                    messageCompanyUser1,
                    messageCompanyUser2
                    //messageCompanyUser3,
                    //messageCompanyUser4,
                    //messageCompanyUser5,
                    //messageCompanyUser6
                }.ForEach(m => context.MessageCompanyUsers.AddOrUpdate(m));

            //MESSAGE PROJECT USER
            var messageProjectUser1 = new MessagePositionUser
                                          {
                                              IsRead = false,
                                              IsStarred = false,
                                              IsSender = false,
                                              Message = message1OutboxUser1InboxUser2,
                                              Position = project15,
                                              MessageFolder = inboxUser2
                                          };
            var messageProjectUser2 = new MessagePositionUser
                                          {
                                              IsRead = false,
                                              IsStarred = false,
                                              IsSender = false,
                                              Message = message1OutboxUser1InboxUser2,
                                              Position = project2,
                                              MessageFolder = inboxUser2
                                          };
            var messageProjectUser3 = new MessagePositionUser
                                          {
                                              IsRead = true,
                                              IsStarred = false,
                                              IsSender = true,
                                              Message = message1OutboxUser1InboxUser2Child1,
                                              Position = project2,
                                              MessageFolder = outboxUser2
                                          };
            var messageProjectUser4 = new MessagePositionUser
                                          {
                                              IsRead = false,
                                              IsStarred = false,
                                              IsSender = false,
                                              Message = message1OutboxUser1InboxUser2Child2,
                                              Position = project2,
                                              MessageFolder = inboxUser2
                                          };
            var messageProjectUser5 = new MessagePositionUser
                                          {
                                              IsRead = false,
                                              IsStarred = false,
                                              IsSender = false,
                                              Message = message2OutboxUser1InboxUser2,
                                              Position = project3,
                                              MessageFolder = inboxUser2
                                          };
            new List<MessagePositionUser>
                {
                    messageProjectUser1,
                    messageProjectUser2,
                    messageProjectUser3,
                    messageProjectUser4,
                    messageProjectUser5
                }.ForEach(m => context.MessagePositionUsers.AddOrUpdate(m));

            //Expert LISTS
            var ExpertList1 = new ExpertList
                                  {
                                      Name = "Asp.Net professionals",
                                      IsBlackList = false,
                                      Owner = user1,
                                      ExpertProfiles = new List<ExpertProfile>
                                                           {
                                                               ExpertProfile3,
                                                               ExpertProfile24,
                                                               ExpertProfile21,
                                                               ExpertProfile2
                                                           }
                                  };
            var ExpertList2 = new ExpertList
                                  {
                                      Name = "Construction experts",
                                      IsBlackList = false,
                                      Owner = user1,
                                      ExpertProfiles = new List<ExpertProfile>
                                                           {
                                                               ExpertProfile5,
                                                               ExpertProfile22,
                                                               ExpertProfile25
                                                           }
                                  };
            var expertBlockList = new ExpertList
                                      {
                                          Name = "Block List",
                                          IsBlackList = true,
                                          Owner = user1,
                                      };
            new List<ExpertList>
                {
                    ExpertList1,
                    ExpertList2,
                    expertBlockList
                }.ForEach(p => context.ExpertLists.AddOrUpdate(p));

            //COMPANY LISTS
            var companyList1 = new CompanyList
                                   {
                                       Name = "IT Companies",
                                       IsBlackList = false,
                                       Owner = user1,
                                       CompanyProfiles = new List<CompanyProfile>
                                                             {
                                                                 companyProfile23,
                                                                 companyProfile2,
                                                                 companyProfile16
                                                             }
                                   };
            var companyList2 = new CompanyList
                                   {
                                       Name = "Medicine Companies",
                                       IsBlackList = false,
                                       Owner = user1,
                                       CompanyProfiles = new List<CompanyProfile>
                                                             {
                                                                 companyProfile3,
                                                                 companyProfile25,
                                                                 companyProfile12
                                                             }
                                   };
            var companyBlockList = new CompanyList
                                       {
                                           Name = "Block List",
                                           IsBlackList = true,
                                           Owner = user1,
                                       };
            new List<CompanyList>
                {
                    companyList1,
                    companyList2,
                    companyBlockList
                }.ForEach(cp => context.CompanyLists.AddOrUpdate(cp));

            //PROJECT LISTS
            var projectList1 = new PositionList
                                   {
                                       Name = "Construction Positions",
                                       IsBlackList = false,
                                       Owner = user1,
                                       Positions = new List<Position>
                                                       {
                                                           project19,
                                                           project22,
                                                           project3
                                                       }
                                   };
            var projectList2 = new PositionList
                                   {
                                       Name = "Mvc/Knockout Positions",
                                       IsBlackList = false,
                                       Owner = user1,
                                       Positions = new List<Position>
                                                       {
                                                           project9,
                                                           project2,
                                                       }
                                   };
            var projectBlockList = new PositionList
                                       {
                                           Name = "Block List",
                                           IsBlackList = true,
                                           Owner = user1,
                                       };
            new List<PositionList>
                {
                    projectList1,
                    projectList2,
                    projectBlockList
                }.ForEach(pr => context.PositionLists.AddOrUpdate(pr));


            context.ObjectContext().SavingChanges += (sender, e) => BeforeSave(GetChangedOrNewEntities(context));

            context.SaveChanges();

            base.Seed(context);
        }

        private IEnumerable<PersistentEntity> GetChangedOrNewEntities(DataContext context)
        {
            const EntityState newOrModified = EntityState.Added | EntityState.Modified;

            return context.ObjectContext().ObjectStateManager.GetObjectStateEntries(newOrModified)
                .Where(x => x.Entity != null).Select(x => x.Entity as PersistentEntity);
        }

        private static bool IsPersistent(PersistentEntity entity)
        {
            return entity.Id != 0;
        }

        private void BeforeSave(IEnumerable<PersistentEntity> entities)
        {
            foreach (var entity in entities)
            {
                entity.Updated = DateTime.Now;
                entity.Created = !IsPersistent(entity) ? DateTime.Now : entity.Created;
            }
        }
    }
}